Hello everyone,
I lost my project and I’m really looking for your help.
I have DS 4.2, SQL server 2008, windows server 2008 and windows 7 (I used to have this project under Central, Production and my local repository)
I can see only project folder and all jobs, workflow, dataflow are missing!!!
I tied to check AL_LANG table I found it empty!!! when trying to create a new job and try to save it, I got the below error in repository:
Internal application error:
Error message:
Cannot save <New_Job> into the repository. Additional database information: <SQL submitted to ODBC data source <000.000.0.000>
resulted in error <[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ‘DB’,
table ‘BODS_TEST.dbo.AL_LANG’; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.>.
The SQL submitted is <INSERT INTO “AL_LANG” (“OBJECT_KEY”, “OBJECT_TYPE”, “NAME”, “VERSION”, “TYPE”, “GUID”, “OWNER”, “DATASTORE”, “NORMNAME”, “STATE”, “CHECKOUT_DT”, “CHECKOUT_REPO”, “CHECKIN_DT”, “CHECKIN_REPO”, “COMMENTS”, “LANGSIZE”, “SEC_USER”, “SEC_USER_COUT”)
VALUES (1, 0, N’New_Job’, 1, 0, N’c0b74588-fd7d-4bb9-b962-5233f9b0b8ce’, NULL, NULL, N’NEW_JOB’, 0, NULL, NULL, NULL, NULL, NULL, 1635, NULL, NULL)
.>.
Any ideas can help me to recover this project, as I can see all details about jobs under dbo.AL_PROJECTS, AL_LANGXMLTEXT, AL_PARENT_CHILD?
But is not coming under Data service designer anymore becuase of AL_LANG become empt 
biplanet (BOB member since 2013-06-20)