IV72673: UNHANDLED EXCEPTION: ORA-01003: NO STATEMENT PARSED

Direct links to fixes

APAR status

Closed as program error.

Error description

PRODUCT : netcool/Impact
release: 6.1.0 / Oracle data source

problem:
           ORA-01003: no statement parsed
 retured when run policy "GEN_24Horas"   here are key lines
from policy
   DataSource = "TICKET_SAP";
   Query = "truncate table genrun";
   CountOnly = False;
   DirectSQL(DataSource, Query, CountOnly);

policy fails
com.micromuse.common.parser.PolicyException: Unhandled
Exception: ORA-01003: no statement parsed   in policy:
GEN_24Horas at line: 26.

=====================
 policy: GEN_24Horas at line: 26
=====================
DirectSQL(DataSource, Query, CountOnly);

customer reports: "I have another Impact,version 5.1.1: and it
works"

Local fix

maybe a work around - need more details from L3, but L3 said if
run update first and then a delete it should work

Problem summary

****************************************************************
* USERS AFFECTED:                                              *
* All Impact Users                                             *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* When running DirectSQL statement, the function will use a    *
* Select context instead of an Update context.                 *
****************************************************************
* RECOMMENDATION:                                              *
* NONE                                                         *
****************************************************************
The DirectSQL function call generates SQL errors when trying to
do a SQL query that doesn't contain a SELECT statement

Problem conclusion

Fixed to allow DirectSQL function to run SQL statements that
don't start with SELECT correctly.

The fix for this APAR is contained in the following
maintenance packages:
|Fix Pack | 6.1.0-TIV-NCI-FP0003
|Fix Pack | 6.1.1-TIV-NCI-FP0004
|Fix Pack | 7.1.0-TIV-NCI-FP0003

Temporary fix

Comments

APAR Information

APAR number
IV72673
Reported component name
NC/IMPACT DSA O
Reported component ID
5724O66OR
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-04-23
Closed date
2015-08-07
Last modified date
2015-08-07

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

Modules/Macros

```
UNKNOWN
```

Fix information

Fixed component name
NC/IMPACT DSA O
Fixed component ID
5724O66OR

Applicable component levels

R610 PSY
UP
R611 PSY
UP
R710 PSY
UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"610","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
07 August 2015

Tips

IV72673: UNHANDLED EXCEPTION: ORA-01003: NO STATEMENT PARSED

Direct links to fixes

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R610 PSY

R611 PSY

R710 PSY

Document Information

Share your feedback

Need support?