My Oracle Support Banner

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 2.7.0.3.0 and later
Information in this document applies to any platform.

Goal

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
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.