user defined scripts gone

[didier.pironet]

Hi guys,
We have a lot of user-defined scripts but today they are all gone for whatever reason.
Built-in scripts still there thought...

Any tips what's the issue here and how to fix??

Thx a million

P.S. We found a table called t_script, query returns null but we see +600 scripts (lines) on this table...
 

[Geert Bellekens]

Easiest fix: restore the backup somewhere, export all scripts (Settings | Transfer | Export Reference Data) and import them into your production model (Settings | Transfer | Import Reference Data)

User defined script are indeed stored in the table t_Script. I'm not sure what you mean by query returns null but we see +600 scripts (lines) on this table...
If you execute select * from t_script in the search window scratch pad, you should see the scripts (and groups, and debug artifacts)

Geert

[didier.pironet]

Thx Geert.
Investigation ongoing...
But I guess we will have to go thru a restore process!

[didier.pironet]

investigation status:
Our DevOps did a select on the script table to find out which script was not returning a result: select * from table script id xxx  or > xxx < xxx
We found out that 2 scripts were not returning result in the query (reason still under investigation)
In the database directly we did a: delete from table where scriptid = xxx and xxx
This helped restore the hundreds user-defined scripts in the Scripting view

[Geert Bellekens]

investigation status:
Our DevOps did a select on the script table to find out witch script was not returning a result: select * from table script id xxx  or > xxx < xxx
We found out that 2 scripts were not returning result in the query (reason still under investigation)
In the database directly we did a: delete from table where scriptid = xxx and xxx
This helped restore the hundreds user-defined scripts in the Scripting view

The investigation will probably not result to anything.
This might be caused by a something like a crash in the middle of saving a script or debugging.

Geert

[didier.pironet]

investigation status:
Our DevOps did a select on the script table to find out witch script was not returning a result: select * from table script id xxx  or > xxx < xxx
We found out that 2 scripts were not returning result in the query (reason still under investigation)
In the database directly we did a: delete from table where scriptid = xxx and xxx
This helped restore the hundreds user-defined scripts in the Scripting view

The investigation will probably not result to anything.
This might be caused by a something like a crash in the middle of saving a script or debugging.

Geert

Root cause is a 'smiley' found in a script that the tool could not handle and crashed miserably...

[Geert Bellekens]

Thanks for reporting back; and for the warning about smiley's 

Geert😍