Tuxedo ART DSNUTILB Wrong Data Conversion With Nullable Columns

(Doc ID 2356149.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle Tuxedo Application Runtime for CICS and Batch - Version 12.2.2 and later
Information in this document applies to any platform.


User encountered the following error while using dsnutilb:

[DSNUTILB]: [20171219 17:33:56.829256]: [ERROR]: [check_db_err] OCI_ERROR - ORA-00917: missing comma
[DSNUTILB]: [20171219 17:33:56.831531]: [DUMP]: [load_parseRecord] CHAR, colvalue=[0000]
[DSNUTILB]: [20171219 17:33:56.836418]: [DUMP]: [check_db_err] End. Check DB error.
[DSNUTILB]: [20171219 17:33:56.839374]: [ERROR]: [execSQLSTMT] Failed to execute SQL(insert into XXXXXXXXXXXXX(XXXXXXXXXXXXXXX,...,XXXXXXXXXX,XXXXX,XXXXXXXXXX) values('   ','YYYYYYY','0000','   ','YYYYYYY',TO_DATE('06.09.2016', 'DD.MM.YYYY'),'KO',TO_TIMESTAMP('2017-08-25-','YYYY-MM-DD-HH24.MI.SS.FF6'),'YYYYYYYYYY',-000000000000000000<3,TO_TIMESTAMP('                         ?','YYYY-MM-DD-HH24.MI.SS.FF6'),-00000000000000<3,TO_TIMESTAMP('YYYYYYYYYYYYYYYYYYYYYYYYYY','YYYY-MM-DD-HH24.MI.SS.FF6'))). rc=-1, errode= 917, errmsg = Error - ORA-00917: missing comma
[DSNUTILB]: [20171219 17:33:56.851453]: [ERROR]: [load_sqlThread] InsertThread[1]:Failed to execute INSERT statement(Record number=[1]).insertstmt=[insert into XXXX.XXXXXXXX(XXXXXXXXXXXXXXX,...,XXXXXXXXXX) values('   ','YYYYYYY','0000','   ','YYYYYYY',TO_DATE('06.09.2016', 'DD.MM.YYYY'),'KO',TO_TIMESTAMP('2017-08-25-','YYYY-MM-DD-HH24.MI.SS.FF6'),'YYYYYYYYYY',-000000000000000000<3,T

User believes wrong conversion by dsnutilb where there are nullable columns, and in user's above case the problem is with NUMBER and TIMESTAMP column type.
User wants to know whether nullable column is supported or not.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms