Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Error

Anybody understand why I'm getting this error?

I used the same temp table strategy for all three tables, it works for the first two, then fails on the last one. I've attached the whole script, and I have pulled out the problematic piece. Why is it trying to find NodeID? I don't have it in my load statement? Any Ideas.

This is the script

LoadTime6:

Load

Max(DateNum) as LastModifiedDate

FROM [CPULoad2.qvd](qvd);

Let vLastExecTime2 = peek('LastModifiedDate');

Drop Table LoadTime2;

I get this error.

Field Not found - <NodeID>

LoadTime6:

Load......

16 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi ,

Would you please tell us after what statement in script you get this error.

Use Debug to find that statement.

Regards,
Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Log file

4/13/2012 12:08:22 PM: 0108 LoadTime6:

4/13/2012 12:08:22 PM: 0109 Load

4/13/2012 12:08:22 PM: 0110 Max(DateNum) as LastModifiedDate

4/13/2012 12:08:22 PM: 0111 FROM (qvd)

4/13/2012 12:08:26 PM: Error: Field not found -

4/13/2012 12:09:51 PM: 0112 Let vLastExecTime2 = peek('LastModifiedDate')

4/13/2012 12:09:51 PM: 0113 Drop Table LoadTime2

4/13/2012 12:09:51 PM: Error: Table not found

4/13/2012 12:09:52 PM: 0115 CPULoad:

Alex Peasley

Business Intelligence Architect

Core BTS

608-661-7769

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Correct me if i am wrong. You mean to say that at line 0111 you are getting error as "field not found - NodeID'?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Correct, no idea why it is saying that.

Alex Peasley

Business Intelligence Architect

Core BTS

608-661-7769

Not applicable
Author

Hi

use the return of select statement in UPPERCASE

.

.

.

InterfaceTrafficDetail:

Load * From [InterfaceTrafficDetail2.qvd](qvd);

Concatenate

LOAD

NODEID,

INTERFACEID AS InterfaceID,

DATE,

Num(floor(DATETIME)) AS DateNum,

DATETIME,

.

.

.

Not applicable
Author

Thats not where the errors is, its in the temp table.

Not applicable
Author

"I get this error.

Field Not found - <NodeID>

LoadTime6:

Load......"

The return of your SQL query must be read in uppercase. Do You got change to see if the error continues?

Sorry, but the error that appears is that the field does not exist. And not with respect to temporary table.

Make a small test:

TMP_TEST:

LOAD

NodeID;

SQL

SELECT NodeID

FROM CoreNOC.dbo.InterfaceTraffic_Detail

WHERE floor (convert (decimal (12,5), DateTime))> = '$ (vLasExecTime3)';

This command runs correctly? My SQL queries return correctly when return on upper case:

TMP_TEST:

LOAD

NODEID;

SQL

SELECT NodeID

FROM CoreNOC.dbo.InterfaceTraffic_Detail

WHERE floor (convert (decimal (12,5), DateTime))> = '$ (vLasExecTime3)';

Not applicable
Author

If I actually take out the 1 and 2 temp tables and run the CPULoad table load on its own, it creates the variable fine and successfully loads. That’s why I’m so confused.

Alex Peasley

Business Intelligence Architect

Core BTS

608-661-7769

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Your table label is "LoadTime6" but your drop statement references LoadTime2?

Can you post yout document log?

-Rob