Databases
StackOverflow2013
Postsdbo
POstartSQLRepository data import error
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POstartSQLRepository data import error
    text
    copied!<p>I'm new to ATG. Recently i started product catalog export/import project in ATG 10.2. I was success in exporting the product catalog. Then i changed the xml file which i got from export and tried to import it. But in my importing process failed with below error. </p> <pre><code>info Sun Jun 23 22:11:55 IST 2013 1372005715997 /atg/commerce/pricing/priceLists/PriceLists SQL Repository startup complete info Sun Jun 23 22:11:56 IST 2013 1372005716133 /atg/multisite/SiteRepository SQL Repository startup complete info Sun Jun 23 22:11:56 IST 2013 1372005716250 /atg/commerce/catalog/ProductCatalog SQL Repository startup complete Nucleus running -- creating definition of product:childxprod2099 **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog SQL Statement Failed: [++SQLInsert++] **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog INSERT INTO crs_product(product_id,email_frnd_enabled,preorderable,use_inv_for_preord) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog VALUES(?,?,?,?) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog -- Parameters -- **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog p[1] = {pd} childxprod2099 (java.lang.String) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog p[2] = {pd: emailAFriendEnabled} true (java.lang.Boolean) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog p[3] = {pd: preorderable} false (java.lang.Boolean) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog p[4] = {pd: useInventoryForPreorder} false (java.lang.Boolean) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog [--SQLInsert--] **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ATGUSER"."CRS_PRODUCT"."ASSET_VERSION") **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) .... *** CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ATGUSER"."CRS_PRODUCT"."ASSET_VERSION") CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ATGUSER"."CRS_PRODUCT"."ASSET_VERSION") at atg.adapter.gsa.GSAItemDescriptor.addItem(GSAItemDescriptor.java:7366) at atg.adapter.gsa.GSARepository.addItem(GSARepository.java:1046) at atg.adapter.gsa.xml.TemplateParser.addItem(TemplateParser.java:1354) ....... at atg.adapter.gsa.xml.TemplateParser.main(TemplateParser.java:5343) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ATGUSER"."CRS_PRODUCT"."ASSET_VERSION") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ............... at atg.adapter.gsa.Table.insert(Table.java:1410) at atg.adapter.gsa.GSAItemDescriptor.addItem(GSAItemDescriptor.java:7339) ... 10 more **** info Sun Jun 23 22:12:00 IST 2013 1372005720124 /atg/dynamo/service/Scheduler Scheduler shutting down. **** info Sun Jun 23 22:12:00 IST 2013 1372005720125 /atg/dynamo/service/Scheduler Scheduler stopped. </code></pre> <p>and below is the file i used to import data.</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="no"?&gt; &lt;!DOCTYPE gsa-template SYSTEM "dynamosystemresource:/atg/dtds/gsa/gsa_1.0.dtd"&gt; &lt;gsa-template&gt; &lt;import-items&gt; &lt;add-item item-descriptor="product" id="childxprod2099"&gt; &lt;set-property name="asset_version"&gt;&lt;![CDATA[1]]&gt;&lt;/set-property&gt; &lt;set-property name="workspace_id"&gt;&lt;![CDATA[11200]]&gt;&lt;/set-property&gt; &lt;set-property name="branch_id"&gt;&lt;![CDATA[1100]]&gt;&lt;/set-property&gt; &lt;set-property name="is_head"&gt;&lt;![CDATA[1]]&gt;&lt;/set-property&gt; &lt;set-property name="version_deleted"&gt;&lt;![CDATA[0]]&gt;&lt;/set-property&gt; &lt;set-property name="version_editable"&gt;&lt;![CDATA[0]]&gt;&lt;/set-property&gt; &lt;set-property name="childSKUs"&gt;&lt;![CDATA[xsku2099,sku10001,sku10002]]&gt;&lt;/set-property&gt; &lt;set-property name="description"&gt;&lt;![CDATA[Modern luxurious comfort and style]]&gt;&lt;/set-property&gt; &lt;set-property name="thumbnailImage"&gt;&lt;![CDATA[m2733]]&gt;&lt;/set-property&gt; &lt;set-property name="brand"&gt;&lt;![CDATA[BrophyBuilt]]&gt;&lt;/set-property&gt; &lt;set-property name="features"&gt;&lt;![CDATA[leather,microfiber]]&gt;&lt;/set-property,&gt; &lt;set-property name="displayName"&gt;&lt;![CDATA[Contemporary Sofa Set]]&gt;&lt;/set-property&gt; &lt;set-property name="fullImage"&gt;&lt;![CDATA[m2732]]&gt;&lt;/set-property&gt; &lt;set-property name="mediumImage"&gt;&lt;![CDATA[xmContemporaryItalianSet]]&gt;&lt;/set-property&gt; &lt;set-property name="longDescription"&gt;&lt;![CDATA[Contemporary and ultra-comfortable, this modern Italian sofa and chair bring European style to your space.]]&gt;&lt;/set-property&gt; &lt;set-property name="smallImage"&gt;&lt;![CDATA[m2731]]&gt;&lt;/set-property&gt; &lt;set-property name="fixedRelatedProducts"&gt;&lt;![CDATA[xprod2055,xprod2057]]&gt;&lt;/set-property&gt; &lt;set-property name="creationDate"&gt;&lt;![CDATA[12/4/2007 13:19:43]]&gt;&lt;/set-property&gt; &lt;set-property name="parentCategoriesForCatalog"&gt;&lt;!`enter code here`[CDATA[homeStoreCatalog=homeStoreSeatingSofas]]&gt;&lt;/set-property&gt; &lt;set-property name="largeImage"&gt;&lt;![CDATA[m2734]]&gt;&lt;/set-property&gt; &lt;set-property name="template"&gt;&lt;![CDATA[m430011]]&gt;&lt;/set-property&gt; &lt;/add-item&gt; &lt;/import-items&gt; &lt;/gsa-template&gt; </code></pre> <p>I need to fix this urgently. Appreciate your comments.</p> <p>Thanks.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload