Import of CSF keeps failing

Kinetic ERP
1

We’re trying to upgrade (and move to a new tenant)

In our test environment, I’m able to install the CSF module. But when I try in the production environment, I’m getting timeouts:

[2/21/2025 9:28:55 PM] Processing Extension definitions...
[2/21/2025 9:31:56 PM] Error An error occurred while reading from the store provider's data reader. See the inner exception for details.
Lock request time out period exceeded.
[2/21/2025 9:31:56 PM] Error Import cancelled or failed for 'EInvoice_1b1ad440-674e-456b-a81d-fcfcfe6e622f'.
[2/21/2025 9:34:56 PM] Error An error occurred while reading from the store provider's data reader. See the inner exception for details.
Lock request time out period exceeded.
[2/21/2025 9:34:56 PM] Error Import cancelled or failed for 'Sweden_285ee131-afee-42db-b26d-4c5e03eaa1e4'.

I’ve tried rebooting the servers to no avail. Nobody is using the servers, and there isn’t any other issues with the installation.

It seems to be a SQL issue, but I’m baffled about what to look at/try next.

2

Run an Sp_who2 in ssms to check if there are any blocking processes.

If you have multiple app servers shut them all down except for your master app server and retry installing the CSF on that, install on the app server not from a client machine.

What CSF are you using?

I’d be inclined to stop any task agents as well.

3

It’s Sweden (SE). I did all that and nothing is showing. If I run it immediately again, it works. I just tried that, so I don’t have a clue what’s going on.

I did it before/after installing task agents…

4

Sorry confused, has worked now, or are you still having issues?

5

I think it’s working if I immediately try again.

I’m going to restore/upgrade the database and try again.

1 Like
6

I found two posts about the error, not for CSF sadly, but it indicates the, just as the errors suggest, you are getting a blocking/locking occurring.

I’m assuming there is part of the sql side of things (DB Scripts Runner) that is making it fail. In the Aus CSF I see an Import_Einvoice scrript, not sure if it is the same, but it appears to operate on the EFTHead table.

It tries to add records into the EFTHead table. But they may be different to the Sweden CSF.

In the Aus version there are some preinstall settings for EInvoice in company maintenance that also need to be carried out, perhaps this is related.

Another thought did come to mind. In the AUS csf it mentions if you have multiple companies when installing the second solution file you only need to check the DELETE PREVIOUS INSTALL for the first company, all subsequent times you don’t… Are you multiple company?

7

Yeah,

The SE is only one company, so I don’t have to worry about that.

Another wrinkle…if I close the “Install Solution” dialog and try again, it fails.

If I don’t close it and retry, it works immediately.

1 Like
8

But it worked perfectly in Test? Is that the same server etc?

9

Different servers, same setup except for one thing. I will test something next to tell me if that one thing is the difference.

Otherwise, I’m stumped.

1 Like
10

Well, I was about to feel stupid. Test is on 2024.2.8, Prod is 2024.2.9.

But after upgrading Test to 2024.2.9 … it still works every single time.

1 Like
11

Just a thought can you run sql profiler when the dB scripts runner is executing to confirm where the problem is, it may be a data issue.

1 Like
12

I’m not saying this was it. But we’re doing our UAT this week and I updated to .10 …

Zero issues now.

Could be something with rebooting SQL server between then and now. Could be the upgrade. I don’t know. But now it’s working just fine.

1 Like