Hi All,
Iam using seqfile--> transformer --> oracleenterprise
iam getting this warning.
When checking operator: When validating export schema: Unrecognized top level format property: nocheck
Warning
Moderators: chulett, rschirm, roy
Are you using LOAD method in the Oracle stage? The message seems to indicate the Oracle stage, but you can test by replacing it with a peek to see if the error remains.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Unrecognized top level format property: nocheck in Oracle
We have made many different attempts to get rid of this pesky msg in our Oracle Load Enterprise stage.
We have failed and have been forced to demote to informational.
For the record we are doing:
Oracle Enterprise (on AIX) stage,; set to LOAD;TRUNCATE;
APT_ORACLE_LOAD_OPTIONS set to : OPTIONS(DIRECT=FALSE)
(we want to do a conventional path load as the files are small)
Stage Options:
Disable constraints=TRUE
index mode=Rebuild
Add Compute statistics=False (It's a small load)
Add Nologging = TRUE
Silently drop=False
Truncate Col names = False
The job runs fine, all rows load correctly, indexes are rebuilt correctly; logs are created etc.
We have tried checking all Field level properties in transform prior to load;
tried adding a transform, putting all variables, datatype changes etc in that xform then mapping to a second with no changes.
None of this worked so we gave up and demoted.
I saw on another thread this is a known issue with Ascential but don't have time to follow up on that.
If you figure it out please post a resolution.
We have failed and have been forced to demote to informational.
For the record we are doing:
Oracle Enterprise (on AIX) stage,; set to LOAD;TRUNCATE;
APT_ORACLE_LOAD_OPTIONS set to : OPTIONS(DIRECT=FALSE)
(we want to do a conventional path load as the files are small)
Stage Options:
Disable constraints=TRUE
index mode=Rebuild
Add Compute statistics=False (It's a small load)
Add Nologging = TRUE
Silently drop=False
Truncate Col names = False
The job runs fine, all rows load correctly, indexes are rebuilt correctly; logs are created etc.
We have tried checking all Field level properties in transform prior to load;
tried adding a transform, putting all variables, datatype changes etc in that xform then mapping to a second with no changes.
None of this worked so we gave up and demoted.
I saw on another thread this is a known issue with Ascential but don't have time to follow up on that.
If you figure it out please post a resolution.
JMS Data Management, Inc