nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD deployment failure

maverick83

Hi,

We are getting the below error in DD deployment ,

[php]

DBD: TUPLE={EventID=templatedata/learning/event/data/us000551, CountryCode=US}
DBD: TTableSchemaHelper object for [EVENTCOUNTRY] found in cache.
DBD: SELECT EventID,CountryCode, Priority,HomeWorthy,HomeDesc FROM EVENTCOUNTRY WHERE EventID=? AND CountryCode=?
DBD: TTableSchemaHelper object for [EVENTCOUNTRY] found in cache.
DBD: WHERE clause parameter 1: templatedata/learning/event/data/us000551
DBD: Column: EventID, field: EventID, Index: 1,Converting 'templatedata/learning/event/data/us000551' to VARCHAR
DBD: WHERE clause parameter 2: US
DBD: Column: CountryCode, field: CountryCode, Index: 2,Converting 'US' to VARCHAR
DBD: Using PreparedStatement for Update...
DBD: TTableSchemaHelper object for [EVENTCOUNTRY] found in cache.
DBD: Columns with Null Values: [Priority, HomeWorthy, HomeDesc]
DBD: TTableSchemaHelper object for [EVENTCOUNTRY] found in cache.
DBD: Value for Priority is null
DBD: Value for HomeWorthy is null
DBD: Value for HomeDesc is null
DBD: Prepared update:UPDATE EVENTCOUNTRY SET WHERE EventID = ? AND CountryCode = ?
DBD: Updating EVENTCOUNTRY
DBD: Value for Priority is null
DBD: Value for HomeWorthy is null
DBD: Value for HomeDesc is null
DBD: Parameter Index: 1, Value: templatedata/learning/event/data/us000551, Converting 'templatedata/learning/event/data/us000551' to VARCHAR
DBD: Column: EventID, field: EventID, Index: 1,Converting 'templatedata/learning/event/data/us000551' to VARCHAR
DBD: Parameter Index: 2, Value: US, Converting 'US' to VARCHAR
DBD: Column: CountryCode, field: CountryCode, Index: 2,Converting 'US' to VARCHAR
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbAgent Smiley Tongue

reparedUpdate()
DBD: Exception Message: [S265024CH3SW04]Incorrect syntax near the keyword 'WHERE'.
DBD: Vendor Error Code: 156
DBD: SQL state: 01000
[/php]

All the mandatory fields are correctly filled up ,i did a google and found that its technically a SQL error ,not a deployment error per se ,

Looking forward for some guidance from experts?

Regards
Mav
TS 6.7.1 On Windows 2003
Microsoft SQL Server 2005

Find more posts tagged with

Comments

maverick83

Any idea regarding this issue?

Regards,
Mav

Migrateduser

Special character being passed (ie single quote)? I don't know, just guessing.

What are the values being passed to the EventID = ? AND CountryCode = ?.

maverick83

thanks for your response ,the values are

eventid="'templatedata/learning/event/data/us000551"
countrycode="us"

till yesterday it was working fine ,now it is giving some weird message without any indication of any real error ,DD really lacks proper messaging facility ,nyways thanks for ur reply

Regards,
Mav

Migrateduser

Ohh... duh. I see it now.

UPDATE EVENTCOUNTRY SET WHERE EventID = ? AND CountryCode = ?

There aren't any values in the above statement. You need some values between SET and WHERE. Looks like two spaces between the SET and WHERE.

Here's an example of what an update should look like.

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

Hyperlink.rptdesign

maverick83

yes that seems logical,thanks a lot again ,

I will check and try to rectify it ,its an db-to-xml and them xml-to-db deployment so may be something went wrong in creating db-to-xml output due to which xml-to-db deployment is failing

Regards,
Mav

ReplaceQuery.rptdesign