The problem I think is that jBilling by default comes with HSQL database. Which has case sensitive table names. If not, it could be a missing script. Can you confirm the jBilling Version, minimum steps to reproduce.
I've changed the jdbc to use with sql server. I've ran the create db script but I'm not seeing any BATCH_JOB_EXECUTION_SEQ table. Only BATCH_JOB_EXECUTION, BATCH_JOB_EXECUTION_CONTEXT, and BATCH_JOB_EXECUTION_PARAMS.
Is there another db script that I could download to see if it contains that table?
jbilling contains scheduled job wish run to perform batch task like the
the billing process need to be configured from the config tab , some
plugins need to be configured also , the documentation describe how to
there is no db batch script ,
my billing process is running since six month, i ve configured it to run
the 1st day of every month at 01h:00 mm
@Ahmed - you are right. And that scheduled job basically
triggers a Spring Batch job. What Greg is facing is failure of
Billing Process due to the failure of the Spring Batch job due to a
missing table. This problem is quite familiar and as far as I can
tell it is a db issue. Most likely HSQL. But could reproduce on
What Greg should share is:
1. Type of DB - I guess it is MS-SQL
2. Steps Greg may have used to initialize the above DB.
After further research, I found that this object is actually a sequence in the database. And I can see it in my database so thats not an issue. I'll have to do some more research to see if Vikas is correct about assuming the default schema. That's what I'm leaning towards.
Since I'm new to the code, I'm trying to find the place in the code where it actually calls this batch job. I have searched for the sequence name (BATCH_JOB_EXECUTION_SEQ) in the source and could not find it. Does anyone know the filename that controls that?
After finding the place to change the default schema, I'm still having the same issue. Is anyone having issues running the billing process on SQL Server? I'm guessing there is a config problem.
getting this error:
org.springframework.dao.DataAccessResourceFailureException: Could not increment identity; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'dbo.BATCH_JOB_SEQ'.
The sequence is in the db. For some reason, the Spring batch cannot see it.
Unfortunately, that doesn't seem to be the issue. I am using SQL_Latin1_General_CP1_CI_AS as the collation, so it's not case sensitive on the db or tables. I did rename the batch_job_seq and batch_job_execution_seq to uppercase to test if it was case sensitive, but I'm still getting the same error.