NT_OshWrapper.exe: cannot execute: command line too long

[Ed Purcell]

Have received following error messages. Anyone have any idea what is going on? Is it really that the tortilla is too big to eat?

Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6644
Event type:Info
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:32:20 PM
Message Id:IIS-DSTAGE-RUN-I-0123
Message:
Contents of phantom output file
E:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.exe: cannot execute: command line too long

Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6645
Event type:Fatal
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:32:20 PM
Message Id:IIS-DSTAGE-RUN-E-0370
Message:
Error setting up internal communications (fifo \\.\pipe\CVI-RT_SC204-CV_SAL_ORDER_TYPE_DS.CV_SAL_ORDER_TYPE_DS_BAAN_UK) STATUS() 2


Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6642
Event type:Info
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:31:16 PM
Message Id:IIS-DSTAGE-RUN-I-0470
Message:
OSH script
# OSH / orchestrate script for Job CV_SAL_ORDER_TYPE_DS compiled at 08:15:23 21 OCT 2013
#################################################################
#### STAGE: Tfm_AddAuditCols_Direct
## Operator
transform
## Operator options
-flag run
-name 'V0S69_CV_SAL_ORDER_TYPE_DS_Tfm_AddAuditCols_Direct'
-argvalue 'DATA_SOURCE=[&"DATA_SOURCE"]'
## General options
[ident('Tfm_AddAuditCols_Direct'); jobmon_ident('Tfm_AddAuditCols_Direct')]
## Inputs
0< [] 'Src_SalesOrderData_Direct_Tbl:lnk_SrcTbl_Direct_In.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out.v'
;
#### STAGE: Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Part
## Operator
hash -key LEGACY_CODE -ci -key LEGACY_DESC -ci -key ORDER_TYPE_CODE -ci -key ORDER_TYPE_DESC -ci
## General options
[ident('Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Part')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part.v'
;
#### STAGE: Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Sort
## Operator
tsort -key LEGACY_CODE -ci -asc -nulls first -key LEGACY_DESC -ci -asc -nulls first -key ORDER_TYPE_CODE -ci -asc -nulls first -key ORDER_TYPE_DESC -ci -asc -nulls first -unique -nonStable
## General options
[ident('Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Sort')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part_Sort.v'
;
#################################################################
#### STAGE: Tgt_Staging_Tbl
## Operator
pxbridge
## Operator options
-Orientation link
-XMLProperties '<?xml version=\'1.0\' encoding=\'UTF-16\'?><Properties version=\'1.1\'><Common><Context type=\'int\'>2</Context><Variant type=\'string\'>4.5</Variant><DescriptorVersion type=\'string\'>1.0</DescriptorVersion><PartitionType type=\'int\'>3</PartitionType><RCP type=\'int\'>0</RCP></Common><Connection><DataSource type=\'string\'><![CDATA[[&"TargetDB.ConnectionString"]]]></DataSource><Database type=\'string\'><![CDATA[[&"TargetDB.Database"]]]></Database><Username type=\'string\'><![CDATA[[&"TargetDB.Username"]]]></Username><Password type=\'string\'><![CDATA[[&"TargetDB.Password"]]]></Password><UseSeparateConnectionForTWT type=\'bool\'><![CDATA[[&"TargetDB.UseSeparateConnectionForTWT"]]]><Database type=\'string\'><![CDATA[[&"TargetDB.DatabaseTWT"]]]></Database><Username type=\'string\'><![CDATA[[&"TargetDB.UsernameTWT"]]]></Username><Password type=\'string\'><![CDATA[[&"TargetDB.PasswordTWT"]]]></Password></UseSeparateConnectionForTWT></Connection><Usage><WriteMode type=\'int\'><![CDATA[0]]></WriteMode><TableName modified=\'1\' type=\'string\'><![CDATA[[&"TGT_TBL_STG"]]]></TableName><EnableCaseSensitiveIDs type=\'bool\'><![CDATA[0]]></EnableCaseSensitiveIDs><TruncateColumnNames type=\'bool\'><![CDATA[0]]></TruncateColumnNames><SQL><DirectInsert type=\'bool\'><![CDATA[0]]></DirectInsert><EnableRecordOrdering collapsed=\'1\' type=\'bool\'><![CDATA[0]]></EnableRecordOrdering><CheckDuplicateRows collapsed=\'1\' type=\'bool\'><![CDATA[0]]></CheckDuplicateRows></SQL><TableAction modified=\'1\' type=\'int\'><![CDATA[3]]><GenerateTruncateStatement modified=\'1\' type=\'bool\'><![CDATA[0]]><FailOnError collapsed=\'1\' type=\'bool\'><![CDATA[1]]></FailOnError><ReadTruncateStatementFromFile type=\'bool\'><![CDATA[0]]></ReadTruncateStatementFromFile><TruncateStatement modified=\'1\' type=\'string\'><![CDATA[Delete from [&"TGT_TBL_STG"] Where DATA_SOURCE=\'[&"DATA_SOURCE"]\' And STATUS_TYPE=\'DIRECT SO TYPE\']]></TruncateStatement></GenerateTruncateStatement></TableAction><Session><SchemaReconciliation><UnmatchedLinkColumnAction type=\'int\'><![CDATA[1]]></UnmatchedLinkColumnAction><TypeMismatchAction modified=\'1\' type=\'int\'><![CDATA[0]]></TypeMismatchAction><UnmatchedTableColumnAction type=\'int\'><![CDATA[1]]></UnmatchedTableColumnAction><MismatchReportingAction modified=\'1\' type=\'int\'><![CDATA[2]]></MismatchReportingAction></SchemaReconciliation><TemporaryWorkTable collapsed=\'1\' type=\'int\'><![CDATA[0]]><DropTable type=\'bool\'><![CDATA[1]]></DropTable></TemporaryWorkTable><LoadOptions collapsed=\'1\'><ValidatePKs collapsed=\'1\' type=\'bool\'><![CDATA[0]]></ValidatePKs><GenerateStatistics collapsed=\'1\' type=\'bool\'><![CDATA[0]]></GenerateStatistics><MaxRejectCount type=\'int\'><![CDATA[1]]></MaxRejectCount></LoadOptions></Session><BeforeAfterSQL collapsed=\'1\' modified=\'1\' type=\'bool\'><![CDATA[0]]></BeforeAfterSQL></Usage></Properties >'
-connector '{
variant=\'4.5\',
library=ccnz,
version=1.0,
variantlist=\'V1;4.5::ccnz\',
versionlist=\'1.0\',
name=NetezzaConnector
}'
-target 0 '{
DSDescription={ORDER_TYPE_CODE=\'\<none\>
Searchable\? N \', ORDER_TYPE_DESC=\'\<none\>
Searchable\? N \', LEGACY_CODE=\'\<none\>
Searchable\? N \', LEGACY_DESC=\'\<none\>
Searchable\? N \', STATUS_TYPE=\'\<none\>
Searchable\? N \', SUBJECT_AREA=\'\<none\>
Searchable\? N \', SOURCE_KEY=\'\<none\>
Searchable\? N \', DATA_SOURCE=\'\<none\>
Searchable\? N \', INSERT_DT=\'\<none\>
Searchable\? N \'},
DSDisplayWidth={ORDER_TYPE_CODE=30, ORDER_TYPE_DESC=100, LEGACY_CODE=30, LEGACY_DESC=30, STATUS_TYPE=30, SUBJECT_AREA=30, SOURCE_KEY=50, DATA_SOURCE=10, INSERT_DT=26},
DSSQLType={ORDER_TYPE_CODE=-9, ORDER_TYPE_DESC=-9, LEGACY_CODE=-9, LEGACY_DESC=-9, STATUS_TYPE=12, SUBJECT_AREA=12, SOURCE_KEY=-9, DATA_SOURCE=12, INSERT_DT=11},
DSDerivation={ORDER_TYPE_CODE=\'vVOrderTypecode\', ORDER_TYPE_DESC=\'If TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca)\=\\\'\\\' Then \"UNSPECIFIED\" Else UpCase(TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca))\', LEGACY_CODE=\'vVOrderTypecode\', LEGACY_DESC=\'If TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca)\=\\\'\\\' Then \"UNSPECIFIED\" Else UpCase(TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca))\', STATUS_TYPE=\'\\\'DIRECT SO TYPE\\\'\', SUBJECT_AREA=\'\\\'SALES\\\'\', SOURCE_KEY=\'vVOrderTypecode\:\\\'\~\\\'\:DATA_SOURCE\', DATA_SOURCE=\'DATA_SOURCE\', INSERT_DT=\'CurrentTimestamp()\'},
DSSQLPrecision={ORDER_TYPE_CODE=15, ORDER_TYPE_DESC=60, LEGACY_CODE=15, LEGACY_DESC=60, STATUS_TYPE=30, SUBJECT_AREA=30, SOURCE_KEY=50, DATA_SOURCE=10, INSERT_DT=26},
DSSQLScale={INSERT_DT=6},
DSSchema=\'record
(
ORDER_TYPE_CODE\:nullable ustring\[max\=15\]\;
ORDER_TYPE_DESC\:nullable ustring\[max\=60\]\;
LEGACY_CODE\:nullable ustring\[max\=15\]\;
LEGACY_DESC\:nullable ustring\[max\=60\]\;
STATUS_TYPE\:nullable string\[max\=30\]\;
SUBJECT_AREA\:nullable string\[max\=30\]\;
SOURCE_KEY\:ustring\[max\=50\]\;
DATA_SOURCE\:string\[max\=10\]\;
INSERT_DT\:timestamp\;
)\'
}'

## General options
[ident('Tgt_Staging_Tbl'); jobmon_ident('Tgt_Staging_Tbl')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part_Sort.v'
;
#################################################################
#### STAGE: Src_SalesOrderData_Direct_Tbl
## Operator
pxbridge
## Operator options
-Orientation link
-XMLProperties '<?xml version=\'1.0\' encoding=\'UTF-16\'?><Properties version=\'1.1\'><Common><Context type=\'int\'>1</Context><Variant type=\'string\'>3.5</Variant><DescriptorVersion type=\'string\'>1.0</DescriptorVersion><PartitionType type=\'int\'>-1</PartitionType><RCP type=\'int\'>0</RCP></Common><Connection><DataSource modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.ConnectionString"]]]></DataSource><Username modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.Username"]]]></Username><Password modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.Password"]]]></Password></Connection><Usage><GenerateSQL type=\'bool\'><![CDATA[0]]></GenerateSQL><EnableQuotedIDs type=\'bool\'><![CDATA[0]]></EnableQuotedIDs><SQL><SelectStatement modified=\'1\' type=\'string\'><![CDATA[select
t_sotp,
t_dsca
from
ttdsls094[&"REG_CODE"]]]><ReadStatementFromFile type=\'bool\'><![CDATA[0]]></ReadStatementFromFile><Tables collapsed=\'1\'><Table type=\'string\'><![CDATA[ttdsls094[&"REG_CODE"]]]></Table></Tables><Parameters collapsed=\'1\'></Parameters><Columns collapsed=\'1\'><Column type=\'string\'><![CDATA[t_dsca,t_dsca,ttdsls094[&"REG_CODE"]]]></Column><Column type=\'string\'><![CDATA[t_sotp,t_sotp,ttdsls094[&"REG_CODE"]]]></Column></Columns></SelectStatement><EnablePartitioning collapsed=\'1\' type=\'bool\'><![CDATA[0]]></EnablePartitioning></SQL><Transaction><RecordCount type=\'int\'><![CDATA[2000]]></RecordCount><EndOfWave collapsed=\'1\' type=\'int\'><![CDATA[0]]></EndOfWave></Transaction><Session><IsolationLevel type=\'int\'><![CDATA[1]]></IsolationLevel><AutocommitMode type=\'int\'><![CDATA[0]]></AutocommitMode><ArraySize type=\'int\'><![CDATA[2000]]></ArraySize><SchemaReconciliation><FailOnSizeMismatch type=\'bool\'><![CDATA[1]]></FailOnSizeMismatch><FailOnTypeMismatch type=\'bool\'><![CDATA[1]]></FailOnTypeMismatch><FailOnCodePageMismatch type=\'bool\'><![CDATA[0]]></FailOnCodePageMismatch></SchemaReconciliation><PassLobLocator collapsed=\'1\' type=\'bool\'><![CDATA[0]]></PassLobLocator><CodePage collapsed=\'1\' type=\'int\'><![CDATA[0]]></CodePage></Session><BeforeAfter collapsed=\'1\' type=\'bool\'><![CDATA[0]]></BeforeAfter></Usage></Properties >'
-connector '{
variant=\'3.5\',
library=ccodbc,
version=1.0,
variantlist=\'V1;3.5::ccodbc\',
versionlist=\'1.0\',
name=ODBCConnector
}'
-source 0 '{
DSDescription={t_sotp=\'\<none\>
Searchable\? N \', t_dsca=\'\<none\>
Searchable\? N \'},
DSDisplayWidth={t_sotp=30, t_dsca=100},
DSSQLType={t_sotp=12, t_dsca=12},
DSSQLPrecision={t_sotp=10, t_dsca=60},
DSSchema=\'record
(
t_sotp\:string\[max\=10\]\;
t_dsca\:ustring\[max\=60\]\;
)\'
}'

## General options
[ident('Src_SalesOrderData_Direct_Tbl'); jobmon_ident('Src_SalesOrderData_Direct_Tbl')]
## Outputs
0> [modify (
t_sotp:not_nullable string[max=10]=t_sotp;
t_dsca:not_nullable ustring[max=60]=t_dsca;
keep
t_sotp,t_dsca;
)] 'Src_SalesOrderData_Direct_Tbl:lnk_SrcTbl_Direct_In.v'
;
# End of OSH code

[asorrell]

I can't see any problem with the named pipe itself, names can be up to 256 characters long. I think the Status 2 error is "can't find the file specified". This would lead me to believe the problem isn't the named pipe, but that the OSHWrapper is failing, causing the pipe to go away.

Out of curiosity - does it fail if you use a shorter invocation name?

I'd say this is a "contact your support rep" kind of issue. Not certain why it is complaining, but since NT_OSHWrapper is an internal command execution that is failing, you'll need IBM's help to fix it. If you do figure it out, please come back and post the solution.