1/22/2009 9:29:25 PM

While running the Rebuilt Index utility, the little metter (progress bar) showing that its almost 99%, it gives an error in SSP, OUT OF MEMORY.. any one have that prob???

Image of error, Click Here

1/23/2009 11:39:01 AM

I can not give an immediate answer to your problem as I have not seen this myself, however here are some questions that I will start by asking.

1.) Have you tried repairing/reinstalling SSP?
2.) How many songs do/did you have within that database?
3.) Exactly which database(s) are you using? - "SongShow Plus"?

If you can answer these then we may be able to narrow it down a bit and eventually either find the problem and fix it or come up with a work around.

1/23/2009 12:01:09 PM

1.) Have you tried repairing/reinstalling SSP?
Yes, I started with Nov Ed. Then back to June, then back to V5.5; Vefore this all the russian songs were showing up ??? ??????..  The after changing Vista unicode language to russian, it started to display songs.  I had 50 songs in the database.  Then I added all the songs into the songs directory, it gave mem error.. so I started to split up the songs.. add 300, rebuild index, then added more, and more and more.. it came to a point, it doesnt add any more and shows the error every time.
2.) How many songs do/did you have within that database?
Currently about 550.  I have a total of 1150 songs.
3.) Exactly which database(s) are you using? - "SongShow Plus"?
Yes, songshow plus/songs.  Then I have 200 or so songs w/ english.songname.sspsongs file name, then the rest are either ukrainian.songname or russian.songname.sspsong.

1/23/2009 4:12:49 PM

I think that the problem that you are having is with the number of songs that you have total.

Before I go any further I think that it would be useful for me to explain a bit about how the song name works within the songs folder - Where you have put "English" or "Ukranian" or "Russian" etc is actually telling SSP what "Collection" the song belongs to which is not the same as a different database. Every song within the "SongShow Plus/Songs" folder is all in only one database.

From memory (I haven't found where it says it yet) SSP can only currently cope with about 1000 songs per database before it is unable to correctly index them. Note to the developers: - Can we have this increased at some point as we are about to hit this barrier and the work around listed below is being used for something slightly different in our install.

Don't despair at what I have just told you above because there is a work around for this (assuming that the database I am going to mention is not already in use).

1.) Re run the SSP install and add the "Stock Hymns" module.
2.) Navigate to "C:\Documents and Settings\All Users\Documents\R-Technics\SongShow Plus\ModuleData\Additional Databases\Stock Hymns\Songs" (obviously if your data file location is non standard then you need to go there instead).
3.) Press "Ctrl + A"
4.) Holding "Ctrl" down deselect the two folders that are present ("Indexes" and "Various")
5.) Delete everything that is still selected (i.e. all the songs).
6.) Move some of your songs (up to you which but I would choose all the songs from one collection for ease but you don't really need me to tell you that) to this songs folder from the "SongShow Plus\Songs" folder.
7.) Optional step - If you want the ability to edit the songs in this new database then you need to go up one level till you find the "Module.ini" file. Open it and change the value of "ReadOnly=" to "0"
8.) Rebuild Indexes on both databases.

This will still appear to give you access to the songs exactly as before and to all intents and purposes will show no differences until you want to add a new song at which point it will ask you which database.

Hope this helps

1/23/2009 5:38:53 PM

I do not think there is a issue with the number of songs SSP can have in it's database.

Last time I checked our database we had approx 2600+ songs.

I notice no performance hit with the number of songs. Nor videos, Images, Slideshows etc.
In total, my Content for SSP is about 200gb.

I'd lean toward the obvious here, What are the Specs of your computer?

1/26/2009 1:33:52 PM

thanks for all the help here.. Do I have to re-install ? or can I just add another database somehow?!?
and really, we have like 1200 songs on SSP v5.5, no probs at all. on SSP7, doesn't let me add more thank like 500 songs.. So I don't think its the number of songs. I think its a glitch of somekind. I am working w/ developers at RTechnics and the creator Doug Reese I think his name is... So hopefully we'll have this issue resolved soon.. I wil keep you all updated, if interested.

as far as my pc specs, i'm sure I'm coverd 

------------------
System Information
------------------
Operating System: Windows Vista™ Home Premium (6.0, Build 6001) Service Pack 1
System Model: Studio 540      
BIOS: BIOS Date: 09/26/08 15:21:57 Ver: 0.0.1
Processor: Intel(R) Core(TM)2 Quad  CPU   Q8200  @ 2.33GHz (4 CPUs), ~2.3GHz
Memory: 8190MB RAM
DirectX Version: DirectX 10
---------------
Display Devices
---------------
Card name: ATI Radeon HD 3450
Dedicated Memory: 248 MB

1/26/2009 2:03:12 PM

Is that the 32 bit or 64 bit version of Vista Home Premium?

In any case, I would call tech support and have them take a look at it.

1/26/2009 2:41:43 PM

Looks like I may be wrong with the qty of songs issue - I just had it stuck in my head that it couldn't cope with more than 1000 in a database for some reason - must be another database program that i'm getting confused with.

1/26/2009 10:55:31 PM

Perhaps SSP is unable to properly handle 8gb of RAM.

I have the same issue with some legacy applications.

1/27/2009 8:09:32 AM

I think the memory error is within SSP itself, and not hardware RAM.  It's somekind of a glitch these developers need to look at.  I mean, is anyone else as disappointed as I am?  I mean, we're talking about a $350+ software. not some $20, $50 program.  I mean I am in contact with the developers and stuff, but I need this PC up and running. 

1/27/2009 10:40:06 AM

Yes, are in contact with you and will continue to work with you on this issue.

As a point of clarification: This is a problem that is related to the use of non-English words. Up to this point, have not included non-English scenarios in any of our testing nor have we officially supported any language other than English. That will change, but this glitch involves an area of use that we do not presently test for.

Supporting other languages isn't just about fixing this "glitch", but also involves ensuring that the things like sorting and searching work as expected withing the database.

1/27/2009 7:11:31 PM

I agree.. But, why I think its a glitch, rather than just a russian language error, because when i rebuild the index with the 580 songs, 370 of them russian, it rebuilds fine. then adding 1 song, it gives the memory error.. then when i remove that same song, it still gives the memory error.. but before i even tried adding that 1 additional song, it rebuilt just fine.. so i hope this additional info helps out the team.  Even though it doesn't rebuild all my songs, i notice that i max out at about 580 songs in any combonation of english/russian.  even 500 english, 80 russian.

2/14/2009 12:24:01 AM

AS of NOW, the Feb, Beta - fixes all my issues.. everything seems to be working properly! fyi to others...