Can we upload the ProductBean and ItemBean separately ?

Discussion:

(too old to reply)

s***@mcsil.com

2007-01-09 08:29:26 UTC

I had a query related to catalog upload in the accelerator:
Is it possible to upload the ProductBean and ItemBean in separately ? I mean, if I have uploaded the ProductBean previously, is it possible to add just the ItemBeans later on?

I tried it a few times but I am getting the following error:
...
...
...
...
...
[1/4/07 12:16:44:537 IST] 0000008c CommerceSrvr I com.ibm.wca.IdResGen.Handler.DefaultHandler DefaultHandler::initialize Using unique index as defined for table [BIDPAYMENT]
[1/4/07 12:16:44:537 IST] 0000008c CommerceSrvr W com.ibm.wca.IdResGen.Handler.DefaultHandler DefaultHandler::initialize The Table [BIDPAYMENT] did not define a resolve key, and there is no unique index on the table
[1/4/07 12:16:44:553 IST] 0000008c CommerceSrvr I com.ibm.wca.IdResGen.Handler.HandlerToken getLookAsideForString Info: SELECT BASEITEM_ID FROM DB2ADMIN.BASEITEM WHERE MEMBER_ID = 7000000000000000051 AND PARTNUMBER = '300001-102110-001'
[1/4/07 12:16:44:569 IST] 0000008c CommerceSrvr I com.ibm.wca.IdResGen.Handler.HandlerToken executeFetch Info: SELECT ITEMSPC_ID FROM DB2ADMIN.ITEMSPC WHERE PARTNUMBER = '300001-102110-001 Item' AND MEMBER_ID = 7000000000000000051
[1/4/07 12:16:44:569 IST] 0000008c CommerceSrvr I com.ibm.wca.IdResGen.Handler.Primary reserveIDPool Locking table "KEYS" for exclusive access.
[1/4/07 12:16:44:584 IST] 0000008c CommerceSrvr I com.ibm.wca.IdResGen.Handler.Primary reserveIDPool Table "KEYS" is unlocked.
[1/4/07 12:16:44:584 IST] 0000008c CommerceSrvr I com.ibm.wca.IdResGen.Handler.HandlerToken getLookAsideForString Info: SELECT ITEMVERSN_ID FROM DB2ADMIN.ITEMVERSN WHERE BASEITEM_ID = itemversn_id_300001-102110-001 AND VERSIONNAME IS NULL
[1/4/07 12:16:44:615 IST] 0000008c CommerceSrvr W com.ibm.wca.IdResGen.Handler.HandlerToken getLookAsideForString Warning: [IBM][CLI Driver][DB2/NT] SQL0206N "ITEMVERSN_ID_300001" is not valid in the context where it is used. SQLSTATE=42703

[1/4/07 12:16:44:631 IST] 0000008c CommerceSrvr E com.ibm.wca.IdResGen.Parser.RecordAttributes updateValue The attribute "ITEMVERSN_ID" is unresolved.
[1/4/07 12:16:44:631 IST] 0000008c CommerceSrvr E com.ibm.wca.IdResGen.IdResolve execute Error parsing the file : nulltemp\catalogimport\10001\wccatalog.xml:TERMINATE
[1/4/07 12:16:44:647 IST] 00000042 CommerceSrvr I com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl performExecute CMN4512I:
UnresolvedID
The attribute "ITEMVERSN_ID" is unresolved.
&ltversionspc
&nbsp&nbspitemspc_id=&quot10251&quot
&nbsp&nbspitemversn_id=&quot&quot
&nbsp&nbspversionspc_id=&***@versionspc_id_300001-102110-001 Item_7000000000000000051_300001-102110-001&quot
&gt
--------------------

[1/4/07 12:16:44:678 IST] 00000042 CommerceSrvr E com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl performExecute IdResolver failed to resolve the input file nulltemp\catalogimport\10001\wccatalog.xml. Ensure the data contained in the input file correctly matches the database schema.
Correlation Identity: 5769ec60-9bbf-11db-bab4-83d7459c8964
Additional Data:
null
Current exception:
Message:
_INF_TEXT
Stack trace:
com.ibm.commerce.exception.ECSystemException:
UnresolvedID
The attribute "ITEMVERSN_ID" is unresolved.
&ltversionspc
&nbsp&nbspitemspc_id=&quot10251&quot
&nbsp&nbspitemversn_id=&quot&quot
&nbsp&nbspversionspc_id=&***@versionspc_id_300001-102110-001 Item_7000000000000000051_300001-102110-001&quot
&gt
--------------------

at com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl.performExecute(IdResolverTaskCmdImpl.java:302)
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java:161)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:335)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java:180)
at com.ibm.commerce.catalogimport.commands.CatalogTransformer.resolveId(CatalogTransformer.java:273)
at com.ibm.commerce.catalogimport.commands.CatalogTransformer.execute(CatalogTransformer.java:158)
at com.ibm.commerce.catalogimport.commands.PublishCatalogFileProcess.transform(PublishCatalogFileProcess.java:1134)
at com.ibm.commerce.catalogimport.commands.PublishCatalogFileProcess.run(PublishCatalogFileProcess.java:1051)
at com.ibm.commerce.scheduler.SchedulerThread.process(SchedulerThread.java:183)
at com.ibm.commerce.scheduler.SchedulerSecurityPriviledgedAction.run(SchedulerSecurityPriviledgedAction.java:59)
at com.ibm.commerce.scheduler.SchedulerThread.run(SchedulerThread.java:125)

End of exception traces.

geo

2007-01-09 21:18:15 UTC

Permalink

No. You cannot load the items later with the current data files you have.
You are referencing the ids previously created for the product in the item
creation XML, but it has no way to resolve them at this later time without
having the product information in the same load file to provide the
resolution. You would have to provide resolution for that information or
the resolved ids for those records to load the items later. If you add the
product CATENTRY, BASEITEM and associated tables you can do this. You would
not need other records for the ProductBean like OFFER, CATENTSHIP,
CATENTDESC, etc.

Post by s***@mcsil.com
Is it possible to upload the ProductBean and ItemBean in separately ? I
mean, if I have uploaded the ProductBean previously, is it possible to add
just the ItemBeans later on?
...
...
...
...
...
[1/4/07 12:16:44:537 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.DefaultHandler DefaultHandler::initialize
Using unique index as defined for table [BIDPAYMENT]
[1/4/07 12:16:44:537 IST] 0000008c CommerceSrvr W
com.ibm.wca.IdResGen.Handler.DefaultHandler DefaultHandler::initialize The
Table [BIDPAYMENT] did not define a resolve key, and there is no unique
index on the table
[1/4/07 12:16:44:553 IST] 0000008c CommerceSrvr I
SELECT BASEITEM_ID FROM DB2ADMIN.BASEITEM WHERE MEMBER_ID =
7000000000000000051 AND PARTNUMBER = '300001-102110-001'
[1/4/07 12:16:44:569 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.HandlerToken executeFetch Info: SELECT
ITEMSPC_ID FROM DB2ADMIN.ITEMSPC WHERE PARTNUMBER = '300001-102110-001
Item' AND MEMBER_ID = 7000000000000000051
[1/4/07 12:16:44:569 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.Primary reserveIDPool Locking table "KEYS"
for exclusive access.
[1/4/07 12:16:44:584 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.Primary reserveIDPool Table "KEYS" is
unlocked.
[1/4/07 12:16:44:584 IST] 0000008c CommerceSrvr I
SELECT ITEMVERSN_ID FROM DB2ADMIN.ITEMVERSN WHERE BASEITEM_ID =
itemversn_id_300001-102110-001 AND VERSIONNAME IS NULL
[1/4/07 12:16:44:615 IST] 0000008c CommerceSrvr W
[IBM][CLI Driver][DB2/NT] SQL0206N "ITEMVERSN_ID_300001" is not valid in
the context where it is used. SQLSTATE=42703
[1/4/07 12:16:44:631 IST] 0000008c CommerceSrvr E
com.ibm.wca.IdResGen.Parser.RecordAttributes updateValue The attribute
"ITEMVERSN_ID" is unresolved.
[1/4/07 12:16:44:631 IST] 0000008c CommerceSrvr E
nulltemp\catalogimport\10001\wccatalog.xml:TERMINATE
[1/4/07 12:16:44:647 IST] 00000042 CommerceSrvr I
com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl
UnresolvedID
The attribute "ITEMVERSN_ID" is unresolved.
&ltversionspc
&nbsp&nbspitemspc_id=&quot10251&quot
&nbsp&nbspitemversn_id=&quot&quot
Item_7000000000000000051_300001-102110-001&quot
&gt
--------------------
[1/4/07 12:16:44:678 IST] 00000042 CommerceSrvr E
com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl
performExecute IdResolver failed to resolve the input file
nulltemp\catalogimport\10001\wccatalog.xml. Ensure the data contained in
the input file correctly matches the database schema.
Correlation Identity: 5769ec60-9bbf-11db-bab4-83d7459c8964
null
_INF_TEXT
UnresolvedID
The attribute "ITEMVERSN_ID" is unresolved.
&ltversionspc
&nbsp&nbspitemspc_id=&quot10251&quot
&nbsp&nbspitemversn_id=&quot&quot
Item_7000000000000000051_300001-102110-001&quot
&gt
--------------------
at
com.ibm.commerce.tools.devtools.publish.tasks.idresolve.IdResolverTaskCmdImpl.performExecute(IdResolverTaskCmdImpl.java:302)
at
com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java:161)
at
com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:335)
at
com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java(Compiled
Code))
at
com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java:180)
at
com.ibm.commerce.catalogimport.commands.CatalogTransformer.resolveId(CatalogTransformer.java:273)
at
com.ibm.commerce.catalogimport.commands.CatalogTransformer.execute(CatalogTransformer.java:158)
at
com.ibm.commerce.catalogimport.commands.PublishCatalogFileProcess.transform(PublishCatalogFileProcess.java:1134)
at
com.ibm.commerce.catalogimport.commands.PublishCatalogFileProcess.run(PublishCatalogFileProcess.java:1051)
at
com.ibm.commerce.scheduler.SchedulerThread.process(SchedulerThread.java:183)
at
com.ibm.commerce.scheduler.SchedulerSecurityPriviledgedAction.run(SchedulerSecurityPriviledgedAction.java:59)
at
com.ibm.commerce.scheduler.SchedulerThread.run(SchedulerThread.java:125)
End of exception traces.

s***@mcsil.com

2007-01-10 09:01:55 UTC

Permalink

Thanks a lot for the explanation, Geo.

Post by geo
No. You cannot load the items later with the current
data files you have.
You are referencing the ids previously created for
the product in the item
creation XML, but it has no way to resolve them at
this later time without
having the product information in the same load file
to provide the
resolution. You would have to provide resolution
for that information or
the resolved ids for those records to load the items
later. If you add the
product CATENTRY, BASEITEM and associated tables you
can do this. You would
not need other records for the ProductBean like
OFFER, CATENTSHIP,
CATENTDESC, etc.
10.sby.ibm.com...

Post by s***@mcsil.com
I had a query related to catalog upload in the
Is it possible to upload the ProductBean and

ItemBean in separately ? I

Post by s***@mcsil.com
mean, if I have uploaded the ProductBean

previously, is it possible to add

Post by s***@mcsil.com
just the ItemBeans later on?
I tried it a few times but I am getting the
...
...
...
...
...
[1/4/07 12:16:44:537 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.DefaultHandler

DefaultHandler::initialize

Post by s***@mcsil.com
Using unique index as defined for table

[BIDPAYMENT]

Post by s***@mcsil.com
[1/4/07 12:16:44:537 IST] 0000008c CommerceSrvr W
com.ibm.wca.IdResGen.Handler.DefaultHandler

DefaultHandler::initialize The

Post by s***@mcsil.com
Table [BIDPAYMENT] did not define a resolve key,

and there is no unique

Post by s***@mcsil.com
index on the table
[1/4/07 12:16:44:553 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.HandlerToken
SELECT BASEITEM_ID FROM DB2ADMIN.BASEITEM WHERE

MEMBER_ID =

Post by s***@mcsil.com
7000000000000000051 AND PARTNUMBER =

'300001-102110-001'

Post by s***@mcsil.com
[1/4/07 12:16:44:569 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.HandlerToken

executeFetch Info: SELECT

Post by s***@mcsil.com
ITEMSPC_ID FROM DB2ADMIN.ITEMSPC WHERE PARTNUMBER =

'300001-102110-001

Post by s***@mcsil.com
Item' AND MEMBER_ID = 7000000000000000051
[1/4/07 12:16:44:569 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.Primary reserveIDPool

Locking table "KEYS"

Post by s***@mcsil.com
for exclusive access.
[1/4/07 12:16:44:584 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.Primary reserveIDPool

Table "KEYS" is

Post by s***@mcsil.com
unlocked.
[1/4/07 12:16:44:584 IST] 0000008c CommerceSrvr I
com.ibm.wca.IdResGen.Handler.HandlerToken
SELECT ITEMVERSN_ID FROM DB2ADMIN.ITEMVERSN WHERE

BASEITEM_ID =

Post by s***@mcsil.com
itemversn_id_300001-102110-001 AND VERSIONNAME IS

NULL

Post by s***@mcsil.com
[1/4/07 12:16:44:615 IST] 0000008c CommerceSrvr W
com.ibm.wca.IdResGen.Handler.HandlerToken
[IBM][CLI Driver][DB2/NT] SQL0206N

"ITEMVERSN_ID_300001" is not valid in

Post by s***@mcsil.com
the context where it is used. SQLSTATE=42703
[1/4/07 12:16:44:631 IST] 0000008c CommerceSrvr E
com.ibm.wca.IdResGen.Parser.RecordAttributes

updateValue The attribute

Post by s***@mcsil.com
"ITEMVERSN_ID" is unresolved.
[1/4/07 12:16:44:631 IST] 0000008c CommerceSrvr E
com.ibm.wca.IdResGen.IdResolve execute Error

nulltemp\catalogimport\10001\wccatalog.xml:TERMINATE

Post by s***@mcsil.com
[1/4/07 12:16:44:647 IST] 00000042 CommerceSrvr I

com.ibm.commerce.tools.devtools.publish.tasks.idresolv
e.IdResolverTaskCmdImpl

Post by s***@mcsil.com
UnresolvedID
The attribute "ITEMVERSN_ID" is unresolved.
&ltversionspc
&nbspitemspc_id=&quot10251"
&nbspitemversn_id=""

110-001

Post by s***@mcsil.com
Item_7000000000000000051_300001-102110-001"
--------------------
[1/4/07 12:16:44:678 IST] 00000042 CommerceSrvr E

com.ibm.commerce.tools.devtools.publish.tasks.idresolv
e.IdResolverTaskCmdImpl

Post by s***@mcsil.com
performExecute IdResolver failed to resolve the

input file

Post by s***@mcsil.com
nulltemp\catalogimport\10001\wccatalog.xml. Ensure

the data contained in

Post by s***@mcsil.com
the input file correctly matches the database

schema.
5769ec60-9bbf-11db-bab4-83d7459c8964

Post by s***@mcsil.com
null
_INF_TEXT
UnresolvedID
The attribute "ITEMVERSN_ID" is unresolved.
&ltversionspc
&nbspitemspc_id=&quot10251"
&nbspitemversn_id=""

110-001

Post by s***@mcsil.com
Item_7000000000000000051_300001-102110-001"
--------------------
at

com.ibm.commerce.tools.devtools.publish.tasks.idresolv
e.IdResolverTaskCmdImpl.performExecute(IdResolverTaskC
mdImpl.java:302)

Post by s***@mcsil.com
at

com.ibm.commerce.command.ECCommandTarget.executeComman
d(ECCommandTarget.java:161)

Post by s***@mcsil.com
at

com.ibm.ws.cache.command.CommandCache.executeCommand(C
ommandCache.java:335)

Post by s***@mcsil.com
at

com.ibm.websphere.command.CacheableCommandImpl.execute
(CacheableCommandImpl.java(Compiled

Post by s***@mcsil.com
Code))
at

com.ibm.commerce.command.AbstractECTargetableCommand.e
xecute(AbstractECTargetableCommand.java:180)

Post by s***@mcsil.com
at

com.ibm.commerce.catalogimport.commands.CatalogTransfo
rmer.resolveId(CatalogTransformer.java:273)

Post by s***@mcsil.com
at

com.ibm.commerce.catalogimport.commands.CatalogTransfo
rmer.execute(CatalogTransformer.java:158)

Post by s***@mcsil.com
at

com.ibm.commerce.catalogimport.commands.PublishCatalog
FileProcess.transform(PublishCatalogFileProcess.java:1
134)

Post by s***@mcsil.com
at

com.ibm.commerce.catalogimport.commands.PublishCatalog
FileProcess.run(PublishCatalogFileProcess.java:1051)

Post by s***@mcsil.com
at

com.ibm.commerce.scheduler.SchedulerThread.process(Sch
edulerThread.java:183)

Post by s***@mcsil.com
at

com.ibm.commerce.scheduler.SchedulerSecurityPriviledge
dAction.run(SchedulerSecurityPriviledgedAction.java:59
)

Post by s***@mcsil.com
at

com.ibm.commerce.scheduler.SchedulerThread.run(Schedul
erThread.java:125)

Post by s***@mcsil.com
End of exception traces.