didier0315
asked on
Cannot add or modify published applications
I'm having an issue modifying and adding published applications. I ran into a problem with my data store and had to move the database to another server. Both of my Citrix boxes lost their connection to the data store. I was able to get it back online but now I'm unable to add, modify or copy any published applications. It will allow me to open up the properties and make changes but when I hit OK none of the changes are applied. There are no error messages within Citrix or in the Event Viewer on the server. None of my permissions have changed and I've tried a couple of different MetaFrame Admin accounts with the same results. Both servers are running PS4 on W2K3 with SP2. The data store is running on same with SQL 2000 installed. Any assistance would be greatly appreciated.
Here is a link to the Citrix KB describing what seems to be the same problem.
http://support.citrix.com/forums/thread.jspa?forumID=1&threadID=61289&tstart=0
Did you follow Citrix guidance on moving a datastore from one server to another? Do you have a good backup of the data store from prior to your experiencing problems with it that you could restore?
http://support.citrix.com/forums/thread.jspa?forumID=1&threadID=61289&tstart=0
Did you follow Citrix guidance on moving a datastore from one server to another? Do you have a good backup of the data store from prior to your experiencing problems with it that you could restore?
ASKER
Unfortunately, I was unable to follow the proper procedure. I should have said that I had a problem with the data store server which is no longer available. Did use a backup of the data store to create the new connection but still no joy. Tried running dsmaint recreatelhc and was no longer able to start the IMA service. Ran DSMAINT VERIFYLHC and got the following error:
An unknown error occurred while reading the entry table.
Verify integrity of MS Access LHC. Recreate corrupted LHC optionally.
DSMAINT VERIFYLHC [ /AUTOREPAIR ]
Ran DSMAINT VERIFYLHC /AUTOREPAIR and received the exact same error message.
An unknown error occurred while reading the entry table.
Verify integrity of MS Access LHC. Recreate corrupted LHC optionally.
DSMAINT VERIFYLHC [ /AUTOREPAIR ]
Ran DSMAINT VERIFYLHC /AUTOREPAIR and received the exact same error message.
I make a new file DSN and do a DSMAINT CONFIG to re-verify your link to the DS. Then bounce the IMA service and let me know if your situation improves.
ASKER
No change. DSMAINT CONFIG returns no errors and the IMA Service starts up with no issues. Still can't make any changes.
Is your database possibly in read only mode? Check the permissions of the SQL or Windows account you have accessing the data store. You should clearly see this user in the Current Activity of SQL. You should assign DB Owner and Public to the datastore.
ASKER
Account has DB Owner and Public and is showing in the Current Activity in SQL. One thing I just noticed is that none of the tables have been modified since I reconnected the servers to the datastore. When I look at the permissions on the individual tables nothing is checked. Not sure what permissions the account should have by default but there's nothing there at all.
ASKER
Just checked under Options on the database and it is not set to Read-only.
So first off, the best way to move a Citrix DB is via the DSMAINT MIGRATE command but it is probably too late for that, right?
Try this out:
- stop the ima service
- from the cmd "dsmaint /recreatelhc"
- start the ima service
Try this out:
- stop the ima service
- from the cmd "dsmaint /recreatelhc"
- start the ima service
ASKER
I already tried this with the results I stated above. (See third comment above) If you have any insight on how to correct that particular issue it would be greatly appreciated.
I don't like to suggest this but how feasible is it to create a new data store and take one of your Citrix servers and make a new farm?
I see this:
Ran DSMAINT VERIFYLHC and got the following error:
An unknown error occurred while reading the entry table.
Verify integrity of MS Access LHC. Recreate corrupted LHC optionally.
DSMAINT VERIFYLHC [ /AUTOREPAIR ]
Ran DSMAINT VERIFYLHC /AUTOREPAIR
But not the command I posted...
Ran DSMAINT VERIFYLHC and got the following error:
An unknown error occurred while reading the entry table.
Verify integrity of MS Access LHC. Recreate corrupted LHC optionally.
DSMAINT VERIFYLHC [ /AUTOREPAIR ]
Ran DSMAINT VERIFYLHC /AUTOREPAIR
But not the command I posted...
ASKER
BLipman
Sorry, I didn't write that out very clearly. In the text of that message I put this:
Tried running dsmaint recreatelhc and was no longer able to start the IMA service. Ran DSMAINT VERIFYLHC and got the following error:
Sorry for the confusion.
dphantom:
I'd prefer not to create a whole new data store but if I can't get this resolved fairly quickly I may have to. I'm really hoping to find a way to avoid that.
Sorry, I didn't write that out very clearly. In the text of that message I put this:
Tried running dsmaint recreatelhc and was no longer able to start the IMA service. Ran DSMAINT VERIFYLHC and got the following error:
Sorry for the confusion.
dphantom:
I'd prefer not to create a whole new data store but if I can't get this resolved fairly quickly I may have to. I'm really hoping to find a way to avoid that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all your help. I ended up having to create a new DS and rebuild everything. Not loads of fun but it's back up and running now.
Well, good to see you are backup. Glad I was able to help out a bit.
ASKER