Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
EmergeAssociates  
#1 Posted : Saturday, March 14, 2015 4:01:35 AM(UTC)
EmergeAssociates
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1

Hi,

 I have been trying to upload new data, specifically new environmental standards, to an older database created in 2012 and there is a recuring msg box that appears when i am clicking various buttons when uploading the standards (and lab files) from the excell file to the database. The message reads

"16364 Invalid SQL statement; expected 'DELETE, 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'." 

 The files seem to upload fine (i.e. they are highlighted in green) but when i am in ESdat itself none of the guidelines show up in the reference tables or appear as a selection when i try to help. 

 I have had no issues with other databases, just this one. I have tried copying the file, and re-installing ESdat/updating to no avail. The licence is for a single computer so i cant try it on another computer and it doesnt work with someone else logged on to the computer.

 Help anyone? 

Warwick Wood  
#2 Posted : Tuesday, March 17, 2015 8:19:49 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

We analysed a copy of the databases, and this was resolved through support.

The issue was that some environmental standards didn't have an "ActionLevelSource" (ie the name of the guideline).  Once these Environmental Standards were removed then the problem was resolved.

Environmental Standards that have this problem can be seen under Data Tables - zRef_Environmental_Standards and filtering for "ActionLevelSource Is Null " 

We are looking into how this could have happened for a future update.

Warwick 

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.