Project

General

Profile

err_table_save.txt

Kyle Hazelwood, 01/15/2015 10:53 AM

 
1
Hi, Guan.  There was an error message regarding page I2 in the MCR elog last night.
2

    
3
00:56:08-   Ops unable to make Owl Shift Save file of Slip Stacking APG | 23. Receiving "Err:insert new rec failed,try to recover old one SQL_SYNTAX" message. - Owen
4
-- Fri Sep 24 00:57:58 comment by...Owen --  The same error is also occurring with the 29 in the slip stacking APG. Moving on.
5

    
6
Your program log had the following entry.
7

    
8
Sep-24-2010 00:40:16  24-SEP-2010 00:39:55 save failed,can't save to active file
9

    
10
This error was apparently generated by your table_rec_w routine.  Is there some way that you can determine what happened?
11

    
12
Thanks,
13
Brian 
14

    
15

    
16
*+092810 solution notes-------------------------------------
17

    
18
This happened actually in I3.
19
a call 'table_save' in hl.cpp led to the SQL_SYNTAX error in table_rec_w.
20

    
21
table_save(i3_table,TRUE,TRUE,(GEN_TABLE)&hlt);
22
casted HL_TABLE to GEN_TABLE leaving much of floats data portion of 
23
GEN_TABLE undefined(unknown)! It was 'working!' for some time but
24
now these 'unknown' made sqlcmd bad!
25

    
26
Solution: made a new hl_save(in line of hl_r and hl_w) to make sure
27
data between HL_TABLE and GEN_TABLE are properly converted.
28

    
29