Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database error - dbnull error

New Member
Posts: 2
Country: United_Kingdom

Database error - dbnull error

My database has been corrupted, when i try to connect i receive the below error

 

1.png

 

I have tried to run a  repair on the database but as soon as i right click it i get this message2.png

 

Please help

Copper Elite Contributor
Posts: 113
Country: Germany

Re: Database error - dbnull error

DO NOT try to fix this yourself. Call your local ACT! consultant.

Data loss is imminent when trying to fix this in the wrong sequence of actions.

Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de
Bronze Elite Contributor
Posts: 1,409
Country: United_Kingdom

Re: Database error - dbnull error

[ Edited ]

Before you do anything else.

 

Stop the SQL service. Copy all the files where your database is stored into a separate folder.

 

Now start SQL again.

 

Type ACTDIAG at Type Here and open ACTDIAG

 

Click on Database, Database  Details List.

 

Can you see a list of databases?

Does your show in the list.

What does it say under Status?

Does it have a value in Size? If the value is 0 I regret that the database may already be beyond repair.

Have you made any backups? If so how long ago?

New Member
Posts: 2
Country: United_Kingdom

Re: Database error - dbnull error

all fixed now.

SQL stopped and it was not repairable. Did an SQL query to do a rollback and resolve this. thanks guys