I am currently using the 8.0.3 release.
I recently installed a new gateway on a production server and I transferred the developed project (copy and paste in the file system).
When I opened a named query on the designer, I met this error:
The above error was not present in the development server.
What could be the reason?
Tell me for further information.
It was good to talk with you at ICC about this. Please let me know the outcome if exporting the resources from the development machine and importing them to your production server.
One other thing I thought about after we talked is how is the database defined in your named query? If it is linked to the project default, your project may need to updated to reflect the correct DB.
I checked again the error above: in a second production server, where the latest 8.0.4 stable release has been installed, the behavior is again the same as posted last week.
The copy&paste operation of the “named-query” folder from the files system of a server to another raises up the parsing error. Instead, the export&import of the zip file solve the issue.
I noticed that this happens for a large number of queries (> 40): where the named query numbers are between 20-25 the copy&paste works fine.
Is it a matter of files size?
Thank you so much.
Would it be possible to send me just the named-query folder via a private message? It could be file size, but that would be something we would want to fix. I also want to confirm that there isn’t something with endline characters that could be causing a problem.
Yes, no problem. Should I use the Message button close to your profile to send you a private message?
That would be perfect. Thanks!
Thank you for the file. What looks to be happening is the named queries look to be missing their data.bin file in the archive you sent me. In every folder there should be the following two files:
While resource.json files exist in your archive, the data.bin files (which contain the definition of the named query) do not. This causes the Gateway to create a empty file which is causing the error you are seeing. We need to understand why this file is missing.
If you look on the gateway where you are creating this archive from (referred to as source gateway going forward):
- Do you see the data.bin file in each of the folders?
- When opening a designer against this project on the source gateway, are the definitions valid?
- What OS is running the Designer for the source Gateway?
- What OS is the source Gateway using?
- Are multiple people developing on the project at any given time?
- How frequent are saves occurring on this gateway (any estimation will help)
We have had reports of user’s losing resource definitions, but we have yet to narrow down how it is occurring. If your source Gateway is missing data.bin files, the above questions will hopefully help us narrow down what might be happening.
I clarified the issue: the fault is from my side. During the commits towards a git repo the data.bin files were excluded from those operations.
I fix the bug and then I let you know if the situation will be ok.