Skip to content

Translation error in static publication #33

@GerardoRodriguezVisus

Description

@GerardoRodriguezVisus

Hello,
We are facing and error with static publication when we include translated basics assets (Literals).

The code we use is:
LocaleService localeService = new DefaultLocaleService(ics);

long dimensionId = DimensionUtils.getDimensionIdForName(ics, locale);

AssetId litTRanslationId = localeService.findTranslation(litAssetId,dimensionId,"SiteDimSetIbis");
if (litTRanslationId != null) {
litData = mgr.readAttributes(litTRanslationId, Arrays.asList("text"));
attrData = litData.getAttributeData("text");
LOGGER.debug("Found literal: " + litTRanslationId.getId()+
"with text: "+(String) attrData.getData());
result = (String) attrData.getData();
}

This code works perfectly to render the proper translation, but when we are exporting to disk we see the rror:

[2014-09-24 11:49:49,149 UTC] [ERROR] [http-9081-1] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO PublishedAssets (ID,PUBKEYID,ASSETTYPE,ASSETID) VALUES (?,?,?,?)
ID = 1378406156613
PUBKEYID = 1378406156612
ASSETTYPE = Literal
ASSETID = 1378402428652
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CSFINTSTG"."PUBLISHEDASSETS"."ASSETDATE")

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    [...]
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)

[2014-09-24 11:49:49,153 UTC] [ERROR] [http-9081-1] [cs.core.db.DBTransaction] TransactionUnit failed to execute
com.fatwire.cs.core.db.TransactionAbortException: addrows failed
at COM.FutureTense.CatalogManager.CatalogEngine$2.execute(CatalogEngine.java:971)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
[...]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
[2014-09-24 11:49:49,156 UTC] [ERROR] [http-9081-1] [fatwire.logging.cs.db] Exception in addrows for table PublishedAssets
com.fatwire.cs.core.db.TransactionAbortException: addrows failed
at COM.FutureTense.CatalogManager.CatalogEngine$2.execute(CatalogEngine.java:971)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
[...]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
[2014-09-24 11:49:49,159 UTC] [INFO ] [http-9081-1] [com.fatwire.logging.cs] XcelExportService: export: Error: errno=-105 on call to catalog manager for table 'PublishedAssets'[/OpenMarket/Xcelerate/PrologActions/Publish/Export/PublishApprovedAssets#OpenMarket/Xcelerate/Actions/BatchPublish]

Because of this, we guess that the dependencies are not correctly logged because if we edit and approve a published page the HTML is not generated. If the page has not literals it works perfectly (preview and exporting).

Do you have any clue or advise?

Thank you very much.
Gerardo

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions