NEXT-VALUE throws 12747 ERROR (You must provide valid connected database name to dynamic....)

R

RobertG

New Member
Hi.
Strange thing. On PASOE we are started to getting 12747 error on NEXT-VALUE(tableseq) line. It's not happening in other environments but on PASOE, and not always. It's a random issue. We are using 12.8.1 version. Clarifying, table do not have a create or write triggers assigned. Tables and Sequences shares same name, but that is not an issue. It's compiled with proper database (triple checked)

CREATE MagicTable. <- This is ok
MagicTable.MagicTableID = NEXT-VALUE(MagicTable). <- Here errors occurs

Any ideas what might happened here?

Robert.
 
Last edited:
That code that you are showing is not a dynamic anything so… either the error message is erroneous or you are looking at the wrong bit of code.

Seeing the full and complete error message would, of course, be helpful. And if there are multiple errors occurring please share all of them.
 
Hi Tom. If You try You'll notice that Progress didn't bother to give a correct message. Static NEXT-VALUE gives that message. Try disconnecting DB with static function.
There is just one message
1725363164910.png
 
Thanks for the complete error message.

I was mistaken, that IS a dynamic something.

Have you tried using NEXT-VALUE( dbName.sequenceName )
 
Yes, we also experience that on this construction NEXT-VALUE(sequenceName, dbName) but we don't have anywhere implemented construction NEXT-VALUE( dbName.sequenceName ) We will try that with new release but I don't think that this might be the case. Additionally, there is no difference whether I create buffer first and then take new sequence value, or other way, first take next value and after that attempt to create buffer.
 
Any suggestion?
Startup parameters?
Memory leaks?

We increasing and extending logging level, but it occurs only on live environment, so we cannot do that instantly.
 
That is also what first came to my mind, but that was what we checked first.
We also tried to simulate that and made compilation with only needed databases, and then statically and dynamically connect additional databases, but that is working well and we don't have any issues.
If we will get more info from logs or we solve that, I'll give a response.
Thank you for your attention and advices.
 
You must log in or register to reply here.
Back
Top