ADSM-L

Operational Reporting error

2004-01-02 10:42:40
Subject: Operational Reporting error
From: "Foresti, Kathie" <kathie.foresti AT LMCO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 2 Jan 2004 10:42:16 -0500
I am getting the following error in the Daily Report
ERROR -- Administrative Schedules
ANS8000I Server command: 'select domain_name, schedule_name, 
node_name,substr(char(scheduled_start), 1, 16) as 
"SCHEDULED_START",substr(char(actual_start), 1, 16) as "ACTUAL_START",status, 
result from events where (scheduled_start between '2004-01-01 10:30' and 
'2004-01-02 10:30') and LENGTH(domain_name) IS NULL and ( (status = 'Future') 
or (status = 'Started') or (status = 'Completed') or (status = 'Pending') or 
(status = 'Failed') or (status = 'Missed')) and (node_name in ('

ANR2903E The SQL statement is incomplete; additional tokens are required.

ANS8001I Return code 3.
ANS8000I Server command: ')) order by scheduled_start,status,result'
ANR2000E Unknown command - )).
ANS8001I Return code 2.
ANS8002I Highest return code was 3.


It does look like the SQL command is getting cut off.  Is there a limitation as 
to how long the command can be?

> Kathie
> Kathie Foresti
> Lockheed Martin Corporation
> Enterprise Information Systems
> Phone (315)456-1941
> E-mail:  Kathie.Foresti AT lmco DOT com
>

<Prev in Thread] Current Thread [Next in Thread>