10/7/2006 2:36:13 AM

We have now got 2000 songs on SSP.  but having a few problems:

backup and restore doesn't work that well, so i copy and paste songs between computers, putting songs in the shared folder (in the songs folder), and then rebuild the indexes.

that has worked for 1000 or so songs. put another 1000 on and did the above,to find a message that said "out of memory" and didn't rebuild the index or collections. (have 1GB of memory)
this has happened on 2 machines.

is there a limit to how many songs you can have on SSP?????

Also had a Catastrophic error, details here:

Call stack:

:0056E5A3 [Ssp.exe] Ffile.TfrmFile.FormDestroy (FFile.pas, line 438)

:40002AC9 [rtl70.bpl]

:4003BE88 [rtl70.bpl]

:4003BA0C [rtl70.bpl]

:4003BA2F [rtl70.bpl]

:40002AC9 [rtl70.bpl]

:40002AF1 [rtl70.bpl]

:4003BA0C [rtl70.bpl]

:4003BA2F [rtl70.bpl]

:4003BA0C [rtl70.bpl]

:4003BA2F [rtl70.bpl]

:0073F26C [vcl70.bpl]

:400185D9 [rtl70.bpl]

:400186A8 [rtl70.bpl]

:0075D1BB [vcl70.bpl]

:0075D06F [vcl70.bpl]

:0075D0EE [vcl70.bpl]

:4003B985 [rtl70.bpl]

:0075AE28 [vcl70.bpl]

:4000C4D0 [rtl70.bpl]

:4000673A [rtl70.bpl]

:005AEA3C [Ssp.exe] initialization

:7C90E64E [ntdll.dll]

:7C816FD7 [kernel32.dll]

 

 

Catastrophic

 

 

Main Thread ID = 00000DA8, Current Thread ID = 00000DA8

Registers:

EAX = 00000000  CS = 001B  EIP = 0056E5A3  Flags = 00010246

EBX = 04B9E17C  SS = 0023  ESP = 0012FE0C    EBP = 0012FF28

ECX = 00E97FC4  DS = 0023  ESI = 00E81880    FS  = 003B

EDX = 04DAF790  ES = 0023  EDI = 04B9E17C    GS  = 0000

Code at CS:EIP

8B 80 18 02 00 00 8B 10 FF 52 44 8D 45 F8 50 8D

Stack:

0012FF30 40005F9C 0012FF28 0012FE58 00EC1178

00000000 00000000 00000000 00000000 7C816FD7

40005B05 04BCC070 4000570B 2A9B400C 0040B30B

00000000 1A6000D8 7C816FD7 FFFFFFFF FFFFFFFF

also have a jpeg picture if you want it of error.

Has anyone else got this number of songs and had this problem?
If you are wondering why so many songs, it is that our churches have 3-4 different books, and we have entered them all in, for convience when ewe have visiting ministers and for our selection.
Hope to put on more yet.

Help please.
Thanks, Jody

 

10/7/2006 7:15:00 PM

I am not sure about the limit, but is it really necessary to have that many songs? Do you have any duplicates than can be eliminated by using program specific verse order? I just cannot fathom that many songs. I hope tech support can provide an answer.

10/9/2006 1:43:48 PM

Hi,  You need to check for updates and download with the latest dated 9/13/6.  It should fix the problems with the catastrophic error.  What happened was that after ssp came out with V7, song select changed their format.  We fixed that in the release update for 9/13/6

10/9/2006 2:01:04 PM

Can you break the songs into different collections? I don't know if that would help. But I think that's what I'd try.

10/10/2006 4:25:35 AM

I have them in 6 collections. was wondering if you could do what the stock hymns/christmas songs have, be able to turn them off and on. Can we put them in the same location and would they register as an entry? in (tools/utilities/song database sources)? then yes, if this was possible,we could reduce the amount of songs.
thanks for your suggestions.
I have upgraded to the latest august update.

10/10/2006 5:23:33 AM

Do you mean the August 2006 Edition, Update 9/13/2006 version?

10/10/2006 9:35:21 AM

That is the edition that I meant. Aug 2006, updated 9-13-2006

10/10/2006 10:40:30 AM

Maybe Doug needs to start numbering them, like

Version 7 August 2006 Edition 09/13/2006 Version 7.06.08.09
Version 7 August 2006 Edition 08/08/2006 Version 7.06.08
Version 7 June 2006 Edition 07/19/2006 Version 7.06.06.08
Version 7 February 2006 Edition 05/25/2006 Version 7.06.02.05

Or he could number them sequentially, rather than with the year and month.

But that way, we can keep track of version, release and modification level.

10/10/2006 11:47:29 PM

Actually, this particular problem is probably not related to the CCLI issue. There is a known problem with large databases and the native SSP database. You might consider using the User Database module which can handle a larger number of songs.

10/12/2006 7:05:35 AM

Yes it can, however it has a couple of bugs with song keys and sequences. If you rely on these then the User Database won't work for you - plus copying 2000 songs into that format would not be fun. Tech support have not given a timeframe for fixing these issues yet.