Data deploy error

Hi,

Iam getting the following error:COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN64] SQL0206N "VERSION_NO" is not valid in the context where it is used. SQLSTATE=42703

I have attached the datadeploy configuration file and log file containing the exception.

Any help appreciated,

TS--6.5
OD--6.1.1
DD--6..1.1
DB2 database.
DD standalone

Thanks,
Msr.

Find more posts tagged with

Comments

nakumar

Following might be the cause for the failure:

SQL0206N "" is not valid in the context where it is used.

Explanation: This error can occur in the following cases:

* For an INSERT or UPDATE statement, the specified column is not a column of the table, or view that was specified as the object of the insert or update.
* For a SELECT or DELETE statement, the specified column is not a column of any of the tables or views identified in a FROM clause in the statement.
* For an ORDER BY clause, the specified column is a correlated column reference in a subselect, which is not allowed.
* For a CREATE TRIGGER statement:
o A reference is made to a column of the subject table without using an OLD or NEW correlation name.
o The left hand side of an assignment in the SET transition-variable statement in the triggered action specifies an old transition variable where only a new transition variable is supported.
* For a CREATE FUNCTION statement:
o The RETURN statement of the SQL function references a variable that is not a parameter or other variable that is in the scope of the RETURN statement.
o The FILTER USING clause references a variable that is not a parameter name or an expression name in the WHEN clause.
o The search target in an index exploitation rule does not match some parameter name of the function that is being created.
o A search argument in an index exploitation rule does not match either an expression name in the EXPRESSION AS clause or a parameter name of the function being created.
* For a CREATE INDEX EXTENSION statement, the RANGE THROUGH clause or the FILTER USING clause references a variable that is not a parameter name that can be used in the clause.

The statement cannot be processed.

User Response: Verify that the names are specified correctly in the SQL statement. For a SELECT statement, ensure that all the required tables are named in the FROM clause. For a subselect in an ORDER BY clause, ensure that there are no correlated column references. If a correlation name is used for a table, verify that subsequent references use the correlation name and not the table name.

For a CREATE TRIGGER statement, ensure that only new transition variables are specified on the left hand side of assignments in the SET transition-variable statement and that any reference to columns of the subject table have a correlation name specified.

sqlcode: -206

sqlstate: 42703

msr

Thanks for your response Narendra.

Actually, iam trying to insert the content in to DB table.
I have given my table structure and the Extended attributes.
Table Name =VERSION
VERSION_NO=Char(4)Primary Key
FILE_PATH=varchar(255)Primary Key

Datadeploy:
Extended Attributes Smiley Sad

Iam setting these values by using iwextattbs -s command)
TeamSite/Metadata/VERSION_NO=ONE
TeamSite/Metadata/FILE_PATH=default/main...

I hope there is no possibility of mismatch of the table fields and extended attributes.

Please let me know if there is any wrong in my process.

Thanks,
msr

nakumar

Is VERSION_NO is the reserved word in DB2? Can you try by giving a different column name?

msr

I have updated the VERSION_NO to VERSION_ID ,Still iam getting the same error.

Thanks,
Msr

nakumar

Can you attach the entire log? Also give a try increasing the data type size from CHAR(4) to varchar(20), to avoid the following:

DBD: Column VERSION_NO not found in array
DBD: WARNING:Value for [VERSION_NO] exceeds column width [ 3 > -1

msr

Narendra,

Please find the attached log file.
We are not able to increase the data type size from CHAR(4) to varchar(20).It is already existing table.

Thanks,
msr

msr

Hi ,

I had updated the dd config as follows:
{column name="VERSION_NO" data-type="CHAR(4)" value-from-attribute="press-release/0/head/0/byline/0/DOC_VERS_ID" allows-null="no" }

{column name="FILE_PATH" data-type="VARCHAR(255)" value-from-attribute="press-release/0/head/0/byline/0/PATH_VRTL_LOC_TEXT" allows-null="no" }

Locating OpenDeploy service.
OpenDeploy server host: localhost, RMI registry port: 9173
Got OpenDeploy service
>>>>>-- Start deployment LIO_dd.
iwodstart running in default synchronous mode.
Need to wait for deployment to complete.
>>>>>-- Deployment LIO_dd finished:
ID: m32 Start time: Wed Apr 30 07:13:15 CDT 2008
Status: Completed.

It is asking for delete-tracker='yes' attribute.Otherwise it is giving error.
Iam not clear about the delete-tracker.What excactly it will do?

If we observe the log, it is deleting DCR.What is happening internally iam not getting.

Please suggest me.

Please find the attached log out put.

msr

Opps...
i found that the data type of VERSION_NO field was changed from CHAR(4) to INTEGER(10).

I have updated the same thing in my dd config,but still iam getting same problem.

Please clarify me, how it will map the DCR fields and EAs to integers?

Thanks,
msr.