2011-04-07 18:36:48 *Exception*-->'fullOrder' doesn't exist in array
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(107): err(''fullOrder'
doe...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1079): verify(false,
''fullOrder' doe...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1787):
valArrayKeyExists(Array, 'fullOrder', 'key fullOrder n...')
#3 C:\Web\PaulH\workingDir2\CustomCardsServices\addToCart.php(10):
stashGet('fullOrder')
#4 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-04-07 18:36:48 echoed
{"resultCode":"EKeyNotFound","errMessage":"'fullOrder' doesn't exist in
array"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-04-07 18:36:52 *Exception*-->Key 'productId' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'productId'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'productId'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\fetchTemplateById.php(8):
pgGet('productId')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-04-07 18:36:52 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'productId' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-04-07 18:36:54 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashGet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-04-07 18:36:54 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-04-07 18:36:54 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashSet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-04-07 18:36:54 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-04-07 18:36:55 *Exception*-->Key 'fullOrder' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'fullOrder'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'fullOrder'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(11):
pgGet('fullOrder')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-04-07 18:36:55 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'fullOrder' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-04-07 18:36:55 '{
"SHIPTOADDRESS1":"Testing, test, UT 84604US",
"SHIPPINGMETHOD":"GROUND",
"SHIPTONAME":"Bob the Tester",
"SHIPTOPHONE":"8016664444",
"SHIPTOEMAIL":"bob@testing.com",
"STEWARDSHIPLOC":"UPB",
"RECSOURCE":"CUSTCARD",
"JOBS":[{"PRODUCTCOUNT":6000,"STATUS":"AUTHORIZE","PRODUCT":{"PRODUCTDTLS
":[{"ITEM":"templateProductId","TRAIT":" ","EXTRATRAIT":"
","INFO":40123},{"ITEM":"greeting","TRAIT":"text","EXTRATRAIT":"
","INFO":"Yo homie,"},{"ITEM":"message","TRAIT":"text","EXTRATRAIT":"
","INFO":"You da best."},{"ITEM":"closing","TRAIT":"text","EXTRATRAIT":"
","INFO":"Peace,\\nJarell"},{"ITEM":"image","TRAIT":"full","EXTRATRAIT":"
","INFO":"some\/path\/name.pdf"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"
","INFO":"some\/path\/name.jpg"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"top","INFO":250},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"left","I
NFO":300},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"zoom","INFO":1.2},{
"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"width","INFO":300},{"ITEM":"im
age","TRAIT":"usr","EXTRATRAIT":"height","INFO":1.2}]}}]
}'. Logged by require_once in
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php at line
12.
2011-04-07 18:36:55 select displayName from job.iProduct where productId
= 40123. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 101.
2011-04-07 18:36:55 [SHIPTOADDRESS1]"Testing, test, UT 84604US"
[SHIPPINGMETHOD]"GROUND"
[SHIPTONAME]"Bob the Tester"
[SHIPTOPHONE]"8016664444"
[SHIPTOEMAIL]"bob@testing.com"
[STEWARDSHIPLOC]"UPB"
[RECSOURCE]"CUSTCARD"
[JOBS][0][PRODUCTCOUNT]6000
[JOBS][0][STATUS]"PRINTING"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][ITEM]"templateProductId"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][TRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][INFO]40123
[JOBS][0][PRODUCT][PRODUCTDTLS][0][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][ITEM]"greeting"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][1][INFO]"Yo homie,"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][ITEM]"message"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][2][INFO]"You da best."
[JOBS][0][PRODUCT][PRODUCTDTLS][2][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][ITEM]"closing"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][3][INFO]"Peace,\\nJarell"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][TRAIT]"full"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][4][INFO]"some\/path\/name.pdf"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][5][INFO]"some\/path\/name.jpg"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][EXTRATRAIT]"top"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][INFO]250
[JOBS][0][PRODUCT][PRODUCTDTLS][6][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][EXTRATRAIT]"left"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][7][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][EXTRATRAIT]"zoom"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][8][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][EXTRATRAIT]"width"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][9][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][EXTRATRAIT]"height"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][10][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][AMOUNT]"0"
[JOBS][0][PRODUCT][VISUAL]"images\/christmascard.png"
[JOBS][0][PRODUCT][PRODUCTTYPE]"customCard"
[JOBS][0][PRODUCT][PRODUCTCASE]"CUSTOM"
[JOBS][0][PRODUCT][PRODUCTDESC]"Brown with Snowflakes4 x 8, custom
photo"
[JOBS][0][PRODUCT][SELLINGPRICE]0.25
[JOBS][0][PRODUCT][DISPLAYNAME]"Christmas Card"
[JOBS][0][PRODUCTTYPE]"customCard"
. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 109.
2011-04-07 18:36:55 insert into JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
. Logged by runSql in C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php at
line 225.
2011-04-07 18:36:55 *Exception*-->Database error: ORA-01400: cannot
insert NULL into ("JOB"."IORDER"."PAYMENTMETHOD") for sql: insert into
JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(226): err('Database
error:...', 'EDatabaseErr')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxDb.php(365): OnyxOracle-
>runSql('insert into JOB...')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(292): OnyxDb-
>insert('JOB.IORDER', Array, NULL, NULL)
#3 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(286): OnyxOracle-
>insert('JOB.IORDER', Array)
#4 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(551): yInsertOrder(Array)
#5 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(561):
yInsertFullOrder(Array)
#6 C:\Web\PaulH\workingDir2\CustomCardsServices\core.php(164):
yInsertFullOrderAndTran(Array, Array)
#7 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(18):
insertCustomCard(Array, Array)
#8
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCardTest.php(76)
: require_once('C:\Web\PaulH\wo...')
#9 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-04-07 18:36:55 echoed
{"resultCode":"EDatabaseErr","errMessage":"Database error: ORA-01400:
cannot insert NULL into (\"JOB\".\"IORDER\".\"PAYMENTMETHOD\") for sql:
insert into JOB.IORDER
\n(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWA
RDSHIPLOC,RECSOURCE)\nvalues ('Testing, test, UT 84604US','GROUND','Bob
the Tester','8016664444','bob@testing.com','UPB','CUSTCARD')\n"}. Logged
by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-04-07 18:36:59 *Exception*-->Open of file named
'..\VariableDataFiles\JobTicketsCsv\customCard-8489285.csv' failed in
FileWriteText
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Open of file
na...', '')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php(85): errIf(true, 'Open
of file na...')
#2 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(530):
fileWriteText('"LINK","ORDERNO...', '..\VariableData...')
#3
C:\Web\PaulH\workingDir2\CustomCardsServices\yPrintJobTicketTest.php(7):
yWriteTicketCsv(8489285)
#4 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-04-07 18:36:59 echoed {"resultCode":"Exception","errMessage":"Open
of file named '..\\VariableDataFiles\\JobTicketsCsv\\customCard-
8489285.csv' failed in FileWriteText"}. Logged by
echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-09-26 06:11:56 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashGet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-09-26 06:11:56 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-09-26 06:14:45 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashSet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-09-26 06:14:45 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-09-26 06:17:34 *Exception*-->'StashDefault' doesn't exist in array
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(107):
err(''StashDefault' ...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1079): verify(false,
''StashDefault' ...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1786):
valArrayKeyExists(Array, 'StashDefault', 'stashKey StashD...')
#3 C:\Web\PaulH\workingDir2\CustomCardsServices\addToCart.php(10):
stashGet('fullOrder')
#4 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-09-26 06:17:34 echoed
{"resultCode":"EKeyNotFound","errMessage":"'StashDefault' doesn't exist
in array"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-09-26 06:28:46 *Exception*-->Key 'fullOrder' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'fullOrder'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'fullOrder'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(11):
pgGet('fullOrder')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-09-26 06:28:46 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'fullOrder' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-09-26 06:32:27 *Exception*-->Key 'productId' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'productId'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'productId'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\fetchTemplateById.php(8):
pgGet('productId')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-09-26 06:32:27 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'productId' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-09-26 06:34:54 select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iOrder o join
job.iJob j on o.link=j.link join
job.iProduct p on j.productId=p.productId left join
job.iProductDtl d on p.productId=d.productId and d.ticketinfo
= 'Y'
where
o.link=8489285
union
select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iorder o join
job.ijob j on j.link = o.link join
job.iproduct p on p.productid = j.productid left join
job.iproductdtl d on (d.productid in (select info from
job.iproductdtl dd
where dd.productid =
p.productid and dd.item = 'templateProductId') and d.ticketinfo = 'Y')
where
o.link = 8489285. Logged by runSql in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php at line 225.
2011-09-26 06:34:54 *Exception*-->Database error: ORA-00904:
"D"."AMOUNT": invalid identifier for sql: select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iOrder o join
job.iJob j on o.link=j.link join
job.iProduct p on j.productId=p.productId left join
job.iProductDtl d on p.productId=d.productId and d.ticketinfo
= 'Y'
where
o.link=8489285
union
select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iorder o join
job.ijob j on j.link = o.link join
job.iproduct p on p.productid = j.productid left join
job.iproductdtl d on (d.productid in (select info from
job.iproductdtl dd
where dd.productid =
p.productid and dd.item = 'templateProductId') and d.ticketinfo = 'Y')
where
o.link = 8489285
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(226): err('Database
error:...', 'EDatabaseErr')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxDb.php(302): OnyxOracle-
>runSql('select?? ...')
#2 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(506): OnyxDb-
>select('select?? ...')
#3
C:\Web\PaulH\workingDir2\CustomCardsServices\yPrintJobTicketTest.php(7):
yWriteTicketCsv(8489285)
#4 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-09-26 06:34:54 echoed
{"resultCode":"EDatabaseErr","errMessage":"Database error: ORA-00904:
\"D\".\"AMOUNT\": invalid identifier for sql: select\r\n
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,\r\n
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,\r\n
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,\r\n
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc\r\n from\r\n job.iOrder o
join\r\n job.iJob j on o.link=j.link join\r\n
job.iProduct p on j.productId=p.productId left join\r\n
job.iProductDtl d on p.productId=d.productId and d.ticketinfo = 'Y'\r\n
where\r\n o.link=8489285\r\n union\r\n\r\n
select\r\n
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,\r\n
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,\r\n
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,\r\n
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc\r\n from\r\n job.iorder o
join\r\n job.ijob j on j.link = o.link join\r\n
job.iproduct p on p.productid = j.productid left join\r\n
job.iproductdtl d on (d.productid in (select info from job.iproductdtl
dd\r\n where dd.productid
= p.productid and dd.item = 'templateProductId') and d.ticketinfo =
'Y')\r\n where\r\n o.link = 8489285"}. Logged by
echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-09-26 06:40:23 '{
"SHIPTOADDRESS1":"Testing, test, UT 84604US",
"SHIPPINGMETHOD":"GROUND",
"SHIPTONAME":"Bob the Tester",
"SHIPTOPHONE":"8016664444",
"SHIPTOEMAIL":"bob@testing.com",
"STEWARDSHIPLOC":"UPB",
"RECSOURCE":"CUSTCARD",
"JOBS":[{"PRODUCTCOUNT":6000,"STATUS":"AUTHORIZE","PRODUCT":{"PRODUCTDTLS
":[{"ITEM":"templateProductId","TRAIT":" ","EXTRATRAIT":"
","INFO":40123},{"ITEM":"greeting","TRAIT":"text","EXTRATRAIT":"
","INFO":"Yo homie,"},{"ITEM":"message","TRAIT":"text","EXTRATRAIT":"
","INFO":"You da best."},{"ITEM":"closing","TRAIT":"text","EXTRATRAIT":"
","INFO":"Peace,\\nJarell"},{"ITEM":"image","TRAIT":"full","EXTRATRAIT":"
","INFO":"some\/path\/name.pdf"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"
","INFO":"some\/path\/name.jpg"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"top","INFO":250},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"left","I
NFO":300},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"zoom","INFO":1.2},{
"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"width","INFO":300},{"ITEM":"im
age","TRAIT":"usr","EXTRATRAIT":"height","INFO":1.2}]}}]
}'. Logged by require_once in
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php at line
12.
2011-09-26 06:40:23 select displayName from job.iProduct where productId
= 40123. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 101.
2011-09-26 06:40:23 [SHIPTOADDRESS1]"Testing, test, UT 84604US"
[SHIPPINGMETHOD]"GROUND"
[SHIPTONAME]"Bob the Tester"
[SHIPTOPHONE]"8016664444"
[SHIPTOEMAIL]"bob@testing.com"
[STEWARDSHIPLOC]"UPB"
[RECSOURCE]"CUSTCARD"
[JOBS][0][PRODUCTCOUNT]6000
[JOBS][0][STATUS]"PRINTING"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][ITEM]"templateProductId"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][TRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][INFO]40123
[JOBS][0][PRODUCT][PRODUCTDTLS][0][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][ITEM]"greeting"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][1][INFO]"Yo homie,"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][ITEM]"message"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][2][INFO]"You da best."
[JOBS][0][PRODUCT][PRODUCTDTLS][2][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][ITEM]"closing"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][3][INFO]"Peace,\\nJarell"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][TRAIT]"full"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][4][INFO]"some\/path\/name.pdf"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][5][INFO]"some\/path\/name.jpg"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][EXTRATRAIT]"top"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][INFO]250
[JOBS][0][PRODUCT][PRODUCTDTLS][6][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][EXTRATRAIT]"left"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][7][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][EXTRATRAIT]"zoom"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][8][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][EXTRATRAIT]"width"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][9][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][EXTRATRAIT]"height"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][10][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][AMOUNT]"0"
[JOBS][0][PRODUCT][VISUAL]"images\/christmascard.png"
[JOBS][0][PRODUCT][PRODUCTTYPE]"customCard"
[JOBS][0][PRODUCT][PRODUCTCASE]"CUSTOM"
[JOBS][0][PRODUCT][PRODUCTDESC]"Brown with Snowflakes4 x 8, custom
photo"
[JOBS][0][PRODUCT][SELLINGPRICE]null
[JOBS][0][PRODUCT][DISPLAYNAME]"Christmas Card"
[JOBS][0][PRODUCTTYPE]"customCard"
. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 109.
2011-09-26 06:40:23 insert into JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
. Logged by runSql in C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php at
line 225.
2011-09-26 06:40:23 *Exception*-->Database error: ORA-01400: cannot
insert NULL into ("JOB"."IORDER"."PAYMENTMETHOD") for sql: insert into
JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(226): err('Database
error:...', 'EDatabaseErr')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxDb.php(365): OnyxOracle-
>runSql('insert into JOB...')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(292): OnyxDb-
>insert('JOB.IORDER', Array, NULL, NULL)
#3 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(286): OnyxOracle-
>insert('JOB.IORDER', Array)
#4 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(551): yInsertOrder(Array)
#5 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(561):
yInsertFullOrder(Array)
#6 C:\Web\PaulH\workingDir2\CustomCardsServices\core.php(164):
yInsertFullOrderAndTran(Array, Array)
#7 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(18):
insertCustomCard(Array, Array)
#8
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCardTest.php(76)
: require_once('C:\Web\PaulH\wo...')
#9 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-09-26 06:40:23 echoed
{"resultCode":"EDatabaseErr","errMessage":"Database error: ORA-01400:
cannot insert NULL into (\"JOB\".\"IORDER\".\"PAYMENTMETHOD\") for sql:
insert into JOB.IORDER
\n(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWA
RDSHIPLOC,RECSOURCE)\nvalues ('Testing, test, UT 84604US','GROUND','Bob
the Tester','8016664444','bob@testing.com','UPB','CUSTCARD')\n"}. Logged
by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-15 11:17:11 '{
"SHIPTOADDRESS1":"Testing, test, UT 84604US",
"SHIPPINGMETHOD":"GROUND",
"SHIPTONAME":"Bob the Tester",
"SHIPTOPHONE":"8016664444",
"SHIPTOEMAIL":"bob@testing.com",
"STEWARDSHIPLOC":"UPB",
"RECSOURCE":"CUSTCARD",
"JOBS":[{"PRODUCTCOUNT":6000,"STATUS":"AUTHORIZE","PRODUCT":{"PRODUCTDTLS
":[{"ITEM":"templateProductId","TRAIT":" ","EXTRATRAIT":"
","INFO":40123},{"ITEM":"greeting","TRAIT":"text","EXTRATRAIT":"
","INFO":"Yo homie,"},{"ITEM":"message","TRAIT":"text","EXTRATRAIT":"
","INFO":"You da best."},{"ITEM":"closing","TRAIT":"text","EXTRATRAIT":"
","INFO":"Peace,\\nJarell"},{"ITEM":"image","TRAIT":"full","EXTRATRAIT":"
","INFO":"some\/path\/name.pdf"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"
","INFO":"some\/path\/name.jpg"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"top","INFO":250},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"left","I
NFO":300},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"zoom","INFO":1.2},{
"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"width","INFO":300},{"ITEM":"im
age","TRAIT":"usr","EXTRATRAIT":"height","INFO":1.2}]}}]
}'. Logged by require_once in
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php at line
12.
2011-10-15 11:17:12 select displayName from job.iProduct where productId
= 40123. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 101.
2011-10-15 11:17:12 [SHIPTOADDRESS1]"Testing, test, UT 84604US"
[SHIPPINGMETHOD]"GROUND"
[SHIPTONAME]"Bob the Tester"
[SHIPTOPHONE]"8016664444"
[SHIPTOEMAIL]"bob@testing.com"
[STEWARDSHIPLOC]"UPB"
[RECSOURCE]"CUSTCARD"
[JOBS][0][PRODUCTCOUNT]6000
[JOBS][0][STATUS]"PRINTING"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][ITEM]"templateProductId"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][TRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][INFO]40123
[JOBS][0][PRODUCT][PRODUCTDTLS][0][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][ITEM]"greeting"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][1][INFO]"Yo homie,"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][ITEM]"message"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][2][INFO]"You da best."
[JOBS][0][PRODUCT][PRODUCTDTLS][2][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][ITEM]"closing"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][3][INFO]"Peace,\\nJarell"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][TRAIT]"full"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][4][INFO]"some\/path\/name.pdf"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][5][INFO]"some\/path\/name.jpg"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][EXTRATRAIT]"top"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][INFO]250
[JOBS][0][PRODUCT][PRODUCTDTLS][6][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][EXTRATRAIT]"left"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][7][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][EXTRATRAIT]"zoom"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][8][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][EXTRATRAIT]"width"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][9][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][EXTRATRAIT]"height"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][10][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][AMOUNT]"0"
[JOBS][0][PRODUCT][VISUAL]"images\/christmascard.png"
[JOBS][0][PRODUCT][PRODUCTTYPE]"customCard"
[JOBS][0][PRODUCT][PRODUCTCASE]"CUSTOM"
[JOBS][0][PRODUCT][PRODUCTDESC]"Brown with Snowflakes4 x 8, custom
photo"
[JOBS][0][PRODUCT][SELLINGPRICE]null
[JOBS][0][PRODUCT][DISPLAYNAME]"Christmas Card"
[JOBS][0][PRODUCTTYPE]"customCard"
. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 109.
2011-10-15 11:17:12 insert into JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
. Logged by runSql in C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php at
line 225.
2011-10-15 11:17:12 *Exception*-->Database error: ORA-01400: cannot
insert NULL into ("JOB"."IORDER"."PAYMENTMETHOD") for sql: insert into
JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(226): err('Database
error:...', 'EDatabaseErr')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxDb.php(365): OnyxOracle-
>runSql('insert into JOB...')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(292): OnyxDb-
>insert('JOB.IORDER', Array, NULL, NULL)
#3 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(286): OnyxOracle-
>insert('JOB.IORDER', Array)
#4 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(551): yInsertOrder(Array)
#5 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(561):
yInsertFullOrder(Array)
#6 C:\Web\PaulH\workingDir2\CustomCardsServices\core.php(164):
yInsertFullOrderAndTran(Array, Array)
#7 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(18):
insertCustomCard(Array, Array)
#8
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCardTest.php(76)
: require_once('C:\Web\PaulH\wo...')
#9 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-15 11:17:12 echoed
{"resultCode":"EDatabaseErr","errMessage":"Database error: ORA-01400:
cannot insert NULL into (\"JOB\".\"IORDER\".\"PAYMENTMETHOD\") for sql:
insert into JOB.IORDER
\n(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWA
RDSHIPLOC,RECSOURCE)\nvalues ('Testing, test, UT 84604US','GROUND','Bob
the Tester','8016664444','bob@testing.com','UPB','CUSTCARD')\n"}. Logged
by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-16 10:00:10 '{
"SHIPTOADDRESS1":"Testing, test, UT 84604US",
"SHIPPINGMETHOD":"GROUND",
"SHIPTONAME":"Bob the Tester",
"SHIPTOPHONE":"8016664444",
"SHIPTOEMAIL":"bob@testing.com",
"STEWARDSHIPLOC":"UPB",
"RECSOURCE":"CUSTCARD",
"JOBS":[{"PRODUCTCOUNT":6000,"STATUS":"AUTHORIZE","PRODUCT":{"PRODUCTDTLS
":[{"ITEM":"templateProductId","TRAIT":" ","EXTRATRAIT":"
","INFO":40123},{"ITEM":"greeting","TRAIT":"text","EXTRATRAIT":"
","INFO":"Yo homie,"},{"ITEM":"message","TRAIT":"text","EXTRATRAIT":"
","INFO":"You da best."},{"ITEM":"closing","TRAIT":"text","EXTRATRAIT":"
","INFO":"Peace,\\nJarell"},{"ITEM":"image","TRAIT":"full","EXTRATRAIT":"
","INFO":"some\/path\/name.pdf"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"
","INFO":"some\/path\/name.jpg"},{"ITEM":"image","TRAIT":"usr","EXTRATRAI
T":"top","INFO":250},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"left","I
NFO":300},{"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"zoom","INFO":1.2},{
"ITEM":"image","TRAIT":"usr","EXTRATRAIT":"width","INFO":300},{"ITEM":"im
age","TRAIT":"usr","EXTRATRAIT":"height","INFO":1.2}]}}]
}'. Logged by require_once in
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php at line
12.
2011-10-16 10:00:11 select displayName from job.iProduct where productId
= 40123. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 101.
2011-10-16 10:00:11 [SHIPTOADDRESS1]"Testing, test, UT 84604US"
[SHIPPINGMETHOD]"GROUND"
[SHIPTONAME]"Bob the Tester"
[SHIPTOPHONE]"8016664444"
[SHIPTOEMAIL]"bob@testing.com"
[STEWARDSHIPLOC]"UPB"
[RECSOURCE]"CUSTCARD"
[JOBS][0][PRODUCTCOUNT]6000
[JOBS][0][STATUS]"PRINTING"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][ITEM]"templateProductId"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][TRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][0][INFO]40123
[JOBS][0][PRODUCT][PRODUCTDTLS][0][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][0][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][ITEM]"greeting"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][1][INFO]"Yo homie,"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][1][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][ITEM]"message"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][2][INFO]"You da best."
[JOBS][0][PRODUCT][PRODUCTDTLS][2][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][2][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][ITEM]"closing"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][TRAIT]"text"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][3][INFO]"Peace,\\nJarell"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][3][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][TRAIT]"full"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][4][INFO]"some\/path\/name.pdf"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][4][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][EXTRATRAIT]" "
[JOBS][0][PRODUCT][PRODUCTDTLS][5][INFO]"some\/path\/name.jpg"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][5][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][EXTRATRAIT]"top"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][INFO]250
[JOBS][0][PRODUCT][PRODUCTDTLS][6][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][6][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][EXTRATRAIT]"left"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][7][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][7][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][EXTRATRAIT]"zoom"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][8][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][8][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][EXTRATRAIT]"width"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][INFO]300
[JOBS][0][PRODUCT][PRODUCTDTLS][9][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][9][AMOUNT]"0"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][ITEM]"image"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][TRAIT]"usr"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][EXTRATRAIT]"height"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][INFO]1.2
[JOBS][0][PRODUCT][PRODUCTDTLS][10][SERVICELOC]"UPB"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][UNITCOUNT]"1"
[JOBS][0][PRODUCT][PRODUCTDTLS][10][AMOUNT]"0"
[JOBS][0][PRODUCT][VISUAL]"images\/christmascard.png"
[JOBS][0][PRODUCT][PRODUCTTYPE]"customCard"
[JOBS][0][PRODUCT][PRODUCTCASE]"CUSTOM"
[JOBS][0][PRODUCT][PRODUCTDESC]"Brown with Snowflakes4 x 8, custom
photo"
[JOBS][0][PRODUCT][SELLINGPRICE]null
[JOBS][0][PRODUCT][DISPLAYNAME]"Christmas Card"
[JOBS][0][PRODUCTTYPE]"customCard"
. Logged by insertCustomCard in
C:\Web\PaulH\workingDir2\CustomCardsServices\core.php at line 109.
2011-10-16 10:00:11 insert into JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
. Logged by runSql in C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php at
line 225.
2011-10-16 10:00:11 *Exception*-->Database error: ORA-01400: cannot
insert NULL into ("JOB"."IORDER"."PAYMENTMETHOD") for sql: insert into
JOB.IORDER
(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWARD
SHIPLOC,RECSOURCE)
values ('Testing, test, UT 84604US','GROUND','Bob the
Tester','8016664444','bob@testing.com','UPB','CUSTCARD')
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(226): err('Database
error:...', 'EDatabaseErr')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxDb.php(365): OnyxOracle-
>runSql('insert into JOB...')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(292): OnyxDb-
>insert('JOB.IORDER', Array, NULL, NULL)
#3 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(286): OnyxOracle-
>insert('JOB.IORDER', Array)
#4 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(551): yInsertOrder(Array)
#5 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(561):
yInsertFullOrder(Array)
#6 C:\Web\PaulH\workingDir2\CustomCardsServices\core.php(164):
yInsertFullOrderAndTran(Array, Array)
#7 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(18):
insertCustomCard(Array, Array)
#8
C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCardTest.php(76)
: require_once('C:\Web\PaulH\wo...')
#9 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-16 10:00:11 echoed
{"resultCode":"EDatabaseErr","errMessage":"Database error: ORA-01400:
cannot insert NULL into (\"JOB\".\"IORDER\".\"PAYMENTMETHOD\") for sql:
insert into JOB.IORDER
\n(SHIPTOADDRESS1,SHIPPINGMETHOD,SHIPTONAME,SHIPTOPHONE,SHIPTOEMAIL,STEWA
RDSHIPLOC,RECSOURCE)\nvalues ('Testing, test, UT 84604US','GROUND','Bob
the Tester','8016664444','bob@testing.com','UPB','CUSTCARD')\n"}. Logged
by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-17 16:57:45 *Exception*-->Key 'productId' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'productId'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'productId'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\fetchTemplateById.php(8):
pgGet('productId')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-17 16:57:45 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'productId' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-17 17:10:27 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashGet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-17 17:10:27 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-17 17:25:38 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashSet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-17 17:25:38 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-17 17:30:19 *Exception*-->Key 'fullOrder' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'fullOrder'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'fullOrder'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(11):
pgGet('fullOrder')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-17 17:30:19 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'fullOrder' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-17 18:09:09 *Exception*-->'StashDefault' doesn't exist in array
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(107):
err(''StashDefault' ...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1079): verify(false,
''StashDefault' ...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1786):
valArrayKeyExists(Array, 'StashDefault', 'stashKey StashD...')
#3 C:\Web\PaulH\workingDir2\CustomCardsServices\addToCart.php(10):
stashGet('fullOrder')
#4 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-17 18:09:09 echoed
{"resultCode":"EKeyNotFound","errMessage":"'StashDefault' doesn't exist
in array"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-18 11:16:43 select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iOrder o join
job.iJob j on o.link=j.link join
job.iProduct p on j.productId=p.productId left join
job.iProductDtl d on p.productId=d.productId and d.ticketinfo
= 'Y'
where
o.link=8489285
union
select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iorder o join
job.ijob j on j.link = o.link join
job.iproduct p on p.productid = j.productid left join
job.iproductdtl d on (d.productid in (select info from
job.iproductdtl dd
where dd.productid =
p.productid and dd.item = 'templateProductId') and d.ticketinfo = 'Y')
where
o.link = 8489285. Logged by runSql in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php at line 225.
2011-10-18 11:16:43 *Exception*-->Database error: ORA-00904:
"D"."AMOUNT": invalid identifier for sql: select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iOrder o join
job.iJob j on o.link=j.link join
job.iProduct p on j.productId=p.productId left join
job.iProductDtl d on p.productId=d.productId and d.ticketinfo
= 'Y'
where
o.link=8489285
union
select
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc
from
job.iorder o join
job.ijob j on j.link = o.link join
job.iproduct p on p.productid = j.productid left join
job.iproductdtl d on (d.productid in (select info from
job.iproductdtl dd
where dd.productid =
p.productid and dd.item = 'templateProductId') and d.ticketinfo = 'Y')
where
o.link = 8489285
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxOracle2.php(226): err('Database
error:...', 'EDatabaseErr')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxDb.php(302): OnyxOracle-
>runSql('select?? ...')
#2 C:\Web\PaulH\workingDir2\PamPhp\pamJob.php(506): OnyxDb-
>select('select?? ...')
#3
C:\Web\PaulH\workingDir2\CustomCardsServices\yPrintJobTicketTest.php(7):
yWriteTicketCsv(8489285)
#4 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-18 11:16:43 echoed
{"resultCode":"EDatabaseErr","errMessage":"Database error: ORA-00904:
\"D\".\"AMOUNT\": invalid identifier for sql: select\r\n
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,\r\n
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,\r\n
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,\r\n
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc\r\n from\r\n job.iOrder o
join\r\n job.iJob j on o.link=j.link join\r\n
job.iProduct p on j.productId=p.productId left join\r\n
job.iProductDtl d on p.productId=d.productId and d.ticketinfo = 'Y'\r\n
where\r\n o.link=8489285\r\n union\r\n\r\n
select\r\n
o.link,o.ordernotes,o.shippingnotes,o.shiptoaddress1,o.stewardshiploc,o.s
hippingmethod,o.recdate,o.recsource,o.shiptoname,\r\n
o.shiptoaddress2,o.shiptocity,o.shiptostate,o.shiptopostalcode,o.shiptoco
untry,o.shiptophone,o.shiptoemail,o.shiptoaddress3,\r\n
o.shiptoaddress4,o.consultant,o.rtsnumber,o.batchnumber,j.jobnotes,j.prod
uctcount,j.jobid,j.producttype,p.productdesc,p.displayname,\r\n
p.productvendor,d.item,d.trait,d.extratrait,d.freetrait,d.info,d.unitcoun
t,d.amount,d.serviceloc\r\n from\r\n job.iorder o
join\r\n job.ijob j on j.link = o.link join\r\n
job.iproduct p on p.productid = j.productid left join\r\n
job.iproductdtl d on (d.productid in (select info from job.iproductdtl
dd\r\n where dd.productid
= p.productid and dd.item = 'templateProductId') and d.ticketinfo =
'Y')\r\n where\r\n o.link = 8489285"}. Logged by
echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-19 01:25:52 *Exception*-->Key 'productId' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'productId'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'productId'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\fetchTemplateById.php(8):
pgGet('productId')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-19 01:25:52 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'productId' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-19 01:43:42 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashGet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-19 01:43:42 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-19 01:56:04 *Exception*-->Key 'key' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key 'key' not
f...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'key' not f...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\stashSet.php(6):
pgGet('key')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-19 01:56:04 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'key' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-19 02:08:24 *Exception*-->Key 'fullOrder' not found
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(88): err('Key
'fullOrder'...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1616): errIf(true, 'Key
'fullOrder'...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\CustomCardsServices\submitCustomCard.php(11):
pgGet('fullOrder')
#3 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-19 02:08:24 echoed {"resultCode":"EKeyNotFound","errMessage":"Key
'fullOrder' not found"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.
2011-10-19 02:20:43 *Exception*-->'StashDefault' doesn't exist in array
#0 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(107):
err(''StashDefault' ...', 'EKeyNotFound')
#1 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1079): verify(false,
''StashDefault' ...', 'EKeyNotFound')
#2 C:\Web\PaulH\workingDir2\OnyxPhp\onyxCore.php(1786):
valArrayKeyExists(Array, 'StashDefault', 'stashKey StashD...')
#3 C:\Web\PaulH\workingDir2\CustomCardsServices\addToCart.php(10):
stashGet('fullOrder')
#4 {main}. Logged by fileLogExceptionStackTrace in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxFiles.php at line 206.
2011-10-19 02:20:43 echoed
{"resultCode":"EKeyNotFound","errMessage":"'StashDefault' doesn't exist
in array"}. Logged by echoLogJsonOnyxException in
C:\Web\PaulH\workingDir2\OnyxPhp\onyxRequest.php at line 77.