Schedule in PostgreSQL

Posted on November 15, 2006 at 5:04am
Hi guys..

Im using postgres as metadata repository. Now im having problem with scheduling....I think is about the data type in postgres.

Any guys can help me...

This is part of the error msg:


org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@188e490 targetAction = com.jaspersoft.jasperserver.war.action.ReportSchedulingListAction@206be6, attributes = map[[empty]]] in state 'listJobs' of flow 'reportSchedulingFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.quartz.JobPersistenceException: Couldn't obtain triggers for job: Bad value for type int : \254\355\000\005sr\000\025org.quartz.JobDataMap\237\260\203\350\277\251\260\313\002\000\001Z\000\023allowsTransientDataxr\000\035org.quartz.utils.DirtyFlagMap\023\346.\255(v\012\316\002\000\002Z\000\005dirtyL\000\003mapt\000\017Ljava/util/Map;xp\001sr\000\021java.util.HashMap\005\007\332\301\303\026`\321\003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\014w\010\000\000\000\020\000\000\000\002t\000\014jobDetailsIDsr\000\016java.lang.Long;\213\344\220\314\217#\337\002\000\001J\000\005valuexr\000\020java.lang.Number\206\254\225\035\013\224\340\213\002\000\000xp\000\000\000\000\000\000\000Ct\000\007jobUsert\000\013jasperadminx\000 [See nested exception: org.postgresql.util.PSQLException: Bad value for type int : \254\355\000\005sr\000\025org.quartz.JobDataMap\237\260\203\350\277\251\260\313\002\000\001Z\000\023allowsTransientDataxr\000\035org.quartz.utils.DirtyFlagMap\023\346.\255(v\012\316\002\000\002Z\000\005dirtyL\000\003mapt\000\017Ljava/util/Map;xp\001sr\000\021java.util.HashMap\005\007\332\301\303\026`\321\003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\014w\010\000\000\000\020\000\000\000\002t\000\014jobDetailsIDsr\000\016java.lang.Long;\213\344\220\314\217#\337\002\000\001J\000\005valuexr\000\020java.lang.Number\206\254\225\035\013\224\340\213\002\000\000xp\000\000\000\000\000\000\000Ct\000\007jobUsert\000\013jasperadminx\000]

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@188e490 targetAction = com.jaspersoft.jasperserver.war.action.ReportSchedulingListAction@206be6, attributes = map[[empty]]] in state 'listJobs' of flow 'reportSchedulingFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.quartz.JobPersistenceException: Couldn't obtain triggers for job: Bad value for type int : \254\355\000\005sr\000\025org.quartz.JobDataMap\237\260\203\350\277\251\260\313\002\000\001Z\000\023allowsTransientDataxr\000\035org.quartz.utils.DirtyFlagMap\023\346.\255(v\012\316\002\000\002Z\000\005dirtyL\000\003mapt\000\017Ljava/util/Map;xp\001sr\000\021java.util.HashMap\005\007\332\301\303\026`\321\003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\014w\010\000\000\000\020\000\000\000\002t\000\014jobDetailsIDsr\000\016java.lang.Long;\213\344\220\314\217#\337\002\000\001J\000\005valuexr\000\020java.lang.Number\206\254\225\035\013\224\340\213\002\000\000xp\000\000\000\000\000\000\000Ct\000\007jobUsert\000\013jasperadminx\000 [See nested exception: org.postgresql.util.PSQLException: Bad value for type int : \254\355\000\005sr\000\025org.quartz.JobDataMap\237\260\203\350\277\251\260\313\002\000\001Z\000\023allowsTransientDataxr\000\035org.quartz.utils.DirtyFlagMap\023\346.\255(v\012\316\002\000\002Z\000\005dirtyL\000\003mapt\000\017Ljava/util/Map;xp\001sr\000\021java.util.HashMap\005\007\332\301\303\026`\321\003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\014w\010\000\000\000\020\000\000\000\002t\000\014jobDetailsIDsr\000\016java.lang.Long;\213\344\220\314\217#\337\002\000\001J\000\005valuexr\000\020java.lang.Number\206\254\225\035\013\224\340\213\002\000\000xp\000\000\000\000\000\000\000Ct\000\007jobUsert\000\013jasperadminx\000]
com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.quartz.JobPersistenceException: Couldn't obtain triggers for job: Bad value for type int : \254\355\000\005sr\000\025org.quartz.JobDataMap\237\260\203\350\277\251\260\313\002\000\001Z\000\023allowsTransientDataxr\000\035org.quartz.utils.DirtyFlagMap\023\346.\255(v\012\316\002\000\002Z\000\005dirtyL\000\003mapt\000\017Ljava/util/Map;xp\001sr\000\021java.util.HashMap\005\007\332\301\303\026`\321\003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\014w\010\000\000\000\020\000\000\000\002t\000\014jobDetailsIDsr\000\016java.lang.Long;\213\344\220\314\217#\337\002\000\001J\000\005valuexr\000\020java.lang.Number\206\254\225\035\013\224\340\213\002\000\000xp\000\000\000\000\000\000\000Ct\000\007jobUsert\000\013jasperadminx\000 [See nested exception: org.postgresql.util.PSQLException: Bad value for type int : \254\355\000\005sr\000\025org.quartz.JobDataMap\237\260\203\350\277\251\260\313\002\000\001Z\000\023allowsTransientDataxr\000\035org.quartz.utils.DirtyFlagMap\023\346.\255(v\012\316\002\000\002Z\000\005dirtyL\000\003mapt\000\017Ljava/util/Map;xp\001sr\000\021java.util.HashMap\005\007\332\301\303\026`\321\003\000\002F\000\012loadFactorI\000\011thresholdxp?@\000\000\000\000\000\014w\010\000\000\000\020\000\000\000\002t\000\014jobDetailsIDsr\000\016java.lang.Long;\213\344\220\314\217#\337\002\000\001J\000\005valuexr\000\020java.lang.Number\206\254\225\035\013\224\340\213\002\000\000xp\000\000\000\000\000\000\000Ct\000\007jobUsert\000\013jasperadminx\000]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getTriggersForJob(JobStoreSupport.java:1361)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getTriggersForJob(JobStoreCMT.java:773)
JasperReports® Server
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago

14 Answers:

Posted on November 16, 2006 at 8:34am
Hi guys...

Anybody have idea on this matter? Please help me to solve it.
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 17, 2006 at 11:15am
You can fix this by changing the js.quartz.properties file:
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
mpenningroth's picture
mpenningroth
1001
Joined: Sep 18 2006 - 12:54am
Last seen: 17 years 2 weeks ago
Posted on November 17, 2006 at 12:19pm
Hi

I´m trying to use Jasper Intelligence with Postgres too, but I´m having many problems to configure it.
I´ve used the JasperIntelligence-1[1].0.1-postgreSQL.zip patche. Have you use the same patche as me?

Thank you very much
rafa's picture
rafa
455
Joined: Sep 12 2006 - 9:20pm
Last seen: 17 years 2 weeks ago
Posted on November 17, 2006 at 10:54pm
Hi...

Actually, i did the JI build (v 1.1.0) from source code.
You may try to build JI + PostgreSQL using the Developer Guide manual.

You you face any problems, let me know, maybe i try my best to help you..
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 20, 2006 at 12:00am
Hi...

Thank you mpenningroth, now the schedule is work..
I haven't test the OLAP. Before tht, did you change any setting there (OLAP) to work with PostgreSQL?
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 20, 2006 at 7:27am
Hi,

Sorry for my "interference" in this thread again.

I´ve downloaded the JI source code. Looking the 'Developers Guide Manual', I think I should do the same but in PostgreSQL instead of MySQL (create the jasperserver database, etc). But, how can I 'modify' the source code in order to make all the changes in my PostgreSQL database and not in MySQL?

Thank you very much!

Rafa
rafa's picture
rafa
455
Joined: Sep 12 2006 - 9:20pm
Last seen: 17 years 2 weeks ago
Posted on November 20, 2006 at 9:36am
As general, there is no changes required in order to build JI with PostgreSQL. Just make sure your settings in .m2 directory are correct.
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 20, 2006 at 9:43am
Please refer this post

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&f...
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 20, 2006 at 10:25am
Hi Anandharaj,

I have red the thread you told me. Can you send the final file 'settings.xml' as you've got?

Thanks again!

Rafa
rafa's picture
rafa
455
Joined: Sep 12 2006 - 9:20pm
Last seen: 17 years 2 weeks ago
Posted on November 22, 2006 at 6:00am
Please find the attached maven setting file.

This is a brief explanation on what i had did.

1. Create a database called jasperserver in postgresql (my case, i create a user/owner for this db called jasperadmin)
2. Create databases for sugarcrm and foodmart in mysql and populate the sample data as in guideline.
3. Run the build process. you might be have problems with repository as mentioned in developer guide, last section (troubleshooting)
4. You need to change a little bit of source code. Actually, this is not a mandatory but its better you better change it to avoid confusing.
* Change the dependency details from mysql to postgresql. The files involved are:
- /jasperserver-api-impl/metadata/pom.xml
- /jasperserver-api-impl/engine/pom.xml
- /jasperserver-unit-test/pom.xml
* groupId=postgresql | artifactId=postgresql | version=8.1-407.jdbc3
5. After this you should be able to run the build successful.

Now you try to build and update me what are the errors that you encounter. Maybe later on i can give some other suggestion/idea
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 22, 2006 at 6:01am
[file name=settings-a2954336d4d138fdd77b380eb0cc9cc5.xml size=3378]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/set...
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 22, 2006 at 6:02am
[file name=jdbc.txt size=935]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/jdb...
Post edited by: anandharaj, at: 2006/11/22 06:06
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Posted on November 22, 2006 at 10:56am
Hi Anandharaj,

It looks better now, but when I build the aplication appears an error. I attach a file called "maven-error.txt" where you can see it.
I think now I´m near finish this...

Thanks a lot

Rafa [file name=maven_error.txt size=6339]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/mav...
rafa's picture
rafa
455
Joined: Sep 12 2006 - 9:20pm
Last seen: 17 years 2 weeks ago
Posted on November 23, 2006 at 2:35am
Some of the POM file is not available in repository, in this case, i create the POM file and place it in a respective folder.

Same as you, the file spring-2.0-m2.pom is not found in jasper's repository, so you just create the file and place it in respective location.

Find the attached file and place it in org/springframework/spring/2.0-m2/

Dont forget to rename it spring-2.0-m2.pom (remove .txt)
[file name=spring_2.txt size=160]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/spr...
anandharaj's picture
anandharaj
7935
Joined: Oct 18 2006 - 5:02pm
Last seen: 9 years 11 months ago
Feedback
randomness