W1-ASSET Validation Program W1ASTOOR Returns ORA Error: ORA-00942: table or view does not exist
(Doc ID 2790208.1)
Last updated on JULY 07, 2021
Applies to:Oracle Utilities Customer to Meter Base - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
When ran W1AST00R as part of conversion FK - Resolve XML for W1_ASSET
ERROR (com.splwg.base.support.sql.PreparedStatementImpl) Error executing iterate for rawSQL:
select ASSET_ID from W1_ASSET t where 'Y' = ? and ASSET_ID between ? and ? and not exists ( select 'x' from WR_ASSET x where x.ASSET_ID = t.ASSET_ID ) order by ASSET_ID /* Prepare SQL for W1AST00R */
with 'string' parameter named 'f1_lowId' to : '000000000000' to indices: 2
with 'string' parameter named 'isEligible' to : 'Y' to indices: 1
with 'string' parameter named 'f1_highId' to : '999999999999' to indices: 3
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not existconversion validation for FK via Resolve XML for W1_ASSET, program crashes ORA-00942: table or view does not exist
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document