Changing An Object In A Workspace Within Siebel Tools Gives And SQL0418N Error

(Doc ID 2277836.1)

Last updated on JUNE 19, 2017

Applies to:

Siebel Tools - Version 16.7 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.7 [IP2016] version, Configuration - Dev Env

Context: IBM DB2 on z/OS.
When changing an object, within a workspace in Siebel Tools, it gives an error when stepping off that object:

ERROR
-----------------------
[IBM][CLI Driver][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value. SQLSTATE=42610
When spooling the SQL and running it manually there is no error in running the statement.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new workspace from the top menu: Workspace – Create
2. Fill in the definitions for the new workspace
3. You will now see that all object are editable
4. When randomly changing a object and stepping off the record it gives the following error:

[IBM][CLI Driver][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value. SQLSTATE=42610

 

SQL and error found from the log:

-----------------------

INSERT INTO Siebel.S_APPLET_INTL (
CONFLICT_ID,
DB_LAST_UPD_SRC,
DB_LAST_UPD,
LAST_UPD,
CREATED,
LAST_UPD_BY,
CREATED_BY,
MODIFICATION_NUM,
WS_SRC_ID,
APP_CD,
INACTIVE_FLG,
LANG_CD,
NAME,
APPLET_ID,
REDO_FLG,
REPOSITORY_ID,
TITLE,
TRANSLATE_FLG,
ROW_ID,
WS_ID,
WS_OBJ_VER,
WS_DELETE_FLG)
SELECT ?, ?, current timestamp, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ? FROM Siebel.S_DUAL WHERE NOT EXISTS (SELECT TBL1.* FROM (SELECT
* FROM Siebel.S_APPLET_INTL WHERE ((WS_ID = '1@928291' AND WS_OBJ_VER<=0) OR
(WS_ID = '1-1FVCVOH'))) TBL1 LEFT OUTER JOIN (SELECT * FROM
Siebel.S_APPLET_INTL WHERE ((WS_ID = '1@928291' AND WS_OBJ_VER<=0) OR (WS_ID
= '1-1FVCVOH'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND (((CASE
TBL1.WS_ID WHEN '1@928291' THEN 0 WHEN '1-1FVCVOH' THEN 1
END)*100000)+(TBL1.WS_OBJ_VER)) < (((CASE TBL2.WS_ID WHEN '1@928291' THEN 0
WHEN '1-1FVCVOH' THEN 1 END)*100000)+(TBL2.WS_OBJ_VER))) WHERE TBL2.WS_SRC_ID

IS NULL AND ((TBL1.APPLET_ID=? AND TBL1.NAME=?) OR (TBL1.APPLET_ID=? AND
TBL1.LANG_CD=? AND TBL1.APP_CD=?)))

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 1: 0

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 2:
Object Manager - Default

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 3:
2017-03-06 12:26:25.000000

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 4:
2017-03-06 12:26:25.000000

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 5:
1-WZVF2N

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 6:
1-WZVF2N

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 7: 0

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 8:
1-1FVCYRL

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 9: STD

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 10: N

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 11: NLD

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 12:
NLD-STD

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 13:
1-1TXBJ-I5H

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 14: N

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 15:
1-1TXBJ-1

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 16: XX

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 17: Y

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 18:
1-1FVCYRL

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 19:
1-1FVCVOH

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 20: 1

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 21: N

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 22:
1-1TXBJ-I5H

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 23:
NLD-STD

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 24:
1-1TXBJ-I5H

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 25: NLD

SQLParseAndExecute Bind Vars 4 0000000258bd1184:0 2017-03-06 12:26:25 26: STD

SQLParseAndExecute Execute 5 0000000258bd1184:0 2017-03-06 12:26:25 0s

ObjMgrBusCompLog Error 1 0000000258bd1184:0 2017-03-06 12:26:25 (clicon.cpp
(3618)) SBL-DBC-00111: An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application
configuration if the problem persists.

DBCLog DBCLogError 1 0000000258bd1184:0 2017-03-06 12:26:25 SQLError:
sqlstate 42610: [IBM][CLI Driver][DB2] SQL0418N The statement was not
processed because the statement contains an invalid use of one of the
following: an untyped parameter marker, the DEFAULT keyword, or a null value.

SQLSTATE=42610

Cause

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