Next sequence error

[martinh]

Hi,

I have the following error:

Code: Select all

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: error getting next sequence for articlelabel_id error getting next sequence for articlelabel_id
     at com.servoy.j2db.dataprocessing.SQLEngine.getNextSequence(SQLEngine.java:890)
     at com.servoy.j2db.dataprocessing.Zgb.getNextSequence(Zgb.java:24)
     at com.servoy.j2db.persistence.Column.getNewRecordValue(Column.java:109)
     at com.servoy.j2db.dataprocessing.SQLSheet.Za(SQLSheet.java:8)
     at com.servoy.j2db.dataprocessing.FoundSet.Zc(FoundSet.java:697)
     at com.servoy.j2db.dataprocessing.FoundSet.Za(FoundSet.java:443)
     at com.servoy.j2db.dataprocessing.FoundSet.Za(FoundSet.java:931)
     at com.servoy.j2db.dataprocessing.FoundSet.newRecord(FoundSet.java:1248)
     at com.servoy.j2db.FormController.Zc(FormController.java:279)
     at com.servoy.j2db.FormController.access$600(FormController.java:162)
     at com.servoy.j2db.FormController$JSForm.js_newRecord(FormController.java:90)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

What is strange about this situation is that it happens on a clone database. On the source database I don't have this problem and on other clones neither.
So the table and sequence definition is OK.
This error also only occurs from development (4.1.4)
How can I fix this?

I already tried the following:

- Check if tables are exactly the same in the source and clone database
- Recalc on all databases for all sequencenumbers
- Recalc sequencenumbers within Eclipse
- Restart application server
- Restart developer

But none of these solved the problem.

Any suggestions?

Martin

[rgansevles]

Martin,

There must be some more in the logs, check servoy_log.txt and servoy_workspace/.metadata/.log for another stack trace just before this one.

Rob

[martinh]

Rob,

I guess you mean this one:

Code: Select all

Caused by: com.servoy.j2db.persistence.RepositoryException: Cannot get sequence for column without sequence settings
   at com.servoy.eclipse.core.repository.Zb.Za(Zb.java:94)
   ... 54 more

But the column has sequence settings.
This setting is used by several clones and only 1 database server is giving this problem

Martin

[martinh]

Rob,

This is probably what you were looking for:

Code: Select all

!ENTRY org.eclipse.dltk.core 4 0 2009-11-20 10:13:54.958
!MESSAGE Error receiving file: /globis_articles/.stp/globis_articles/forms/articlelabels/articlelabels_methods.js content: retrying(4)
!STACK 1
org.eclipse.core.runtime.CoreException: File not found: C:\Users\Martin\servoy_workspace\globis_articles\.stp\globis_articles\forms\articlelabels\articlelabels_methods.js.
   at org.eclipse.core.internal.filesystem.Policy.error(Policy.java:55)
   at org.eclipse.core.internal.filesystem.local.LocalFile.openInputStream(LocalFile.java:336)
   at org.eclipse.core.internal.localstore.FileSystemResourceManager.read(FileSystemResourceManager.java:616)
   at org.eclipse.core.internal.resources.File.getContents(File.java:287)
   at org.eclipse.dltk.internal.core.util.Util.getResourceContentsAsCharArray(Util.java:530)
   at org.eclipse.dltk.internal.core.FileCacheStub.get(FileCacheStub.java:45)
   at org.eclipse.dltk.internal.core.util.Util.getResourceContentsAsCharArray(Util.java:474)
   at org.eclipse.dltk.internal.core.SourceModule.getBufferContent(SourceModule.java:421)
   at org.eclipse.dltk.internal.core.AbstractSourceModule.getSourceAsCharArray(AbstractSourceModule.java:316)
   at org.eclipse.dltk.internal.core.builder.AbstractBuildContext.getContents(AbstractBuildContext.java:63)
   at org.eclipse.dltk.core.builder.ParserBuildParticipantFactory$ParserBuildParticipant.build(ParserBuildParticipantFactory.java:81)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildModule(StandardScriptBuilder.java:229)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildNatureModules(StandardScriptBuilder.java:155)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildModules(StandardScriptBuilder.java:126)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildModelElements(StandardScriptBuilder.java:50)
   at org.eclipse.dltk.internal.core.builder.ScriptBuilder.buildElements(ScriptBuilder.java:822)
   at org.eclipse.dltk.internal.core.builder.ScriptBuilder.fullBuild(ScriptBuilder.java:500)
   at org.eclipse.dltk.internal.core.builder.ScriptBuilder.build(ScriptBuilder.java:240)
   at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:624)
   at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:166)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:197)
   at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:246)
   at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:249)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:214)
   at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:353)
   at org.eclipse.core.internal.resources.Project.internalBuild(Project.java:494)
   at org.eclipse.core.internal.resources.Project.build(Project.java:75)
   at com.servoy.eclipse.core.ServoyModel$3.run(ServoyModel.java:1)
   at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
org.eclipse.core.runtime.CoreException[271]: java.io.FileNotFoundException: C:\Users\Martin\servoy_workspace\globis_articles\.stp\globis_articles\forms\articlelabels\articlelabels_methods.js (The system cannot find the path specified)
   at java.io.FileInputStream.open(Native Method)
   at java.io.FileInputStream.<init>(Unknown Source)
   at org.eclipse.core.internal.filesystem.local.LocalFile.openInputStream(LocalFile.java:327)
   at org.eclipse.core.internal.localstore.FileSystemResourceManager.read(FileSystemResourceManager.java:616)
   at org.eclipse.core.internal.resources.File.getContents(File.java:287)
   at org.eclipse.dltk.internal.core.util.Util.getResourceContentsAsCharArray(Util.java:530)
   at org.eclipse.dltk.internal.core.FileCacheStub.get(FileCacheStub.java:45)
   at org.eclipse.dltk.internal.core.util.Util.getResourceContentsAsCharArray(Util.java:474)
   at org.eclipse.dltk.internal.core.SourceModule.getBufferContent(SourceModule.java:421)
   at org.eclipse.dltk.internal.core.AbstractSourceModule.getSourceAsCharArray(AbstractSourceModule.java:316)
   at org.eclipse.dltk.internal.core.builder.AbstractBuildContext.getContents(AbstractBuildContext.java:63)
   at org.eclipse.dltk.core.builder.ParserBuildParticipantFactory$ParserBuildParticipant.build(ParserBuildParticipantFactory.java:81)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildModule(StandardScriptBuilder.java:229)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildNatureModules(StandardScriptBuilder.java:155)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildModules(StandardScriptBuilder.java:126)
   at org.eclipse.dltk.internal.core.builder.StandardScriptBuilder.buildModelElements(StandardScriptBuilder.java:50)
   at org.eclipse.dltk.internal.core.builder.ScriptBuilder.buildElements(ScriptBuilder.java:822)
   at org.eclipse.dltk.internal.core.builder.ScriptBuilder.fullBuild(ScriptBuilder.java:500)
   at org.eclipse.dltk.internal.core.builder.ScriptBuilder.build(ScriptBuilder.java:240)
   at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:624)
   at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:166)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:197)
   at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:246)
   at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:249)
   at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:214)
   at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:353)
   at org.eclipse.core.internal.resources.Project.internalBuild(Project.java:494)
   at org.eclipse.core.internal.resources.Project.build(Project.java:75)
   at com.servoy.eclipse.core.ServoyModel$3.run(ServoyModel.java:1)
   at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

How can I fix this?

Martin

[martinh]

Rob,

I think there is some problem in developer when renaming forms.
When I look at the error, I see that it references to formname 'articlelabels'
This formname doesn't exist anymore, it was renamed some while ago.
But for some reason, the repository thinks that this form is still there.

Martin

[rgansevles]

Martin,

Some unrelated problems are mixed in here.
Regarding the first one, check the sequence settings for articlelabel_id in all clone-servers, the must be the same.

What is your setting for startAsTeamProvider?

Rob

[martinh]

Regarding the first one, check the sequence settings for articlelabel_id in all clone-servers, the must be the same.

You have found the right issue. For the clone that I was testing, the sequence was none in stead of servoy sequence.
After setting this correct, the problem was solved.

Is there a way that I can find if clones do not have same settings as the master?

What is your setting for startAsTeamProvider?

My local application server FALSE; The centrale application server TRUE

[rossent]

We have the same issue in Servoy Developer - the Servoy Sequences are not generated when the database connection was switched at runtime from the "master" to a clone.
We do not (and should not have to) create dbi files for the clones - Servoy must use the dbi information from the master and apply it to all other DBs that are clones from it. This is how it works on the Application Server and that must also work in Servoy Developer.

[lvostinar]

We have the same issue in Servoy Developer - the Servoy Sequences are not generated when the database connection was switched at runtime from the "master" to a clone.
We do not (and should not have to) create dbi files for the clones - Servoy must use the dbi information from the master and apply it to all other DBs that are clones from it. This is how it works on the Application Server and that must also work in Servoy Developer.

The issue about dbi of clone servers will be fixed in 7.2 (when a master dbi changes in developer, all its clones will be changed also).