The ftp server we are trying to reach is a mainframe running z/os Operating System with IBM Tcpip stack.
I would like to request that you add FTPS support in ART for destinations and reporting/scheduling reports.
The Art 5.9 is working great now. Thanks for all the help.
sixth and last
fifth
fourth
third
second
Now come screen captures of the art gui logs first one
I did a fresh upgrade and I have attached my results.
I cant seem to access any reports or create new ones due to the error Column not found: TIME_COLUMN_FORMAT on the Art v5.7
I dont know if this is an issue or not but I have always set Connection Pool Library to ART-DBCP and now its not available.
Ok, so i setup a test report that does just a SELECT 1 FROM sysibm.sysdummy1; and it works for all my datasources on v5.3 - when i go into art v5.7 the initial screen that lists all the reports gets this error: An error occurred java.sql.SQLException: Column not found: TIME_COLUMN_FORMAT Query: SELECT * FROM ART_QUERIES AQ WHERE AQ.ACTIVE=1 AND AQ.HIDDEN<>1 AND AQ.QUERY_TYPE NOT IN(120,119,121,150,161) AND( EXISTS (SELECT * FROM ART_USER_REPORT_MAP AURM WHERE AURM.REPORT_ID=AQ.QUERY_ID AND AURM.USER_ID=?)...
that filesystem is mounted read only and its controlled by another software group (not mine)
Both are available in the classpath but I'm thinking i'm using the type4 drivers so I think that would be db2jcc4.jar
DB2 for z/OS Version 11
The PLIPC TDS is a db2 database I have been running in this configuration since 2012 and really dont want to change it
yes, you are correct.
odd i'm seeing a jdbc:mondarin in the definitions and i never set it there trace is attached
here it is
here is the pic of the art logs
OK, deleted that file and i was able to get in. It took several errors. I will attach stack traces of the Art startup and a picture of the ART logs to see if you want any of those stack traces.
after the restart i try to access art through the browser and get the following error.
I restarted the server and got the errors I attached here. Will get you the stacktrace now.
when i change the DBType to Demo and leave the other fields alone I get the same error. Other fields are DBProtocol HSQLDB Url demo when i change the DBType to Demo and change the url to mine I get the same error.
art logs attachment
After upgrading from Art 5.3 to 5.7 on initial setup via browser I get the following error: Error: java.lang.AbstractMethodError: java/sql/Connection.isValid(I)Z I will attach detail files.
OK, I will, thanks
after upgrading Art from v4.8 to v4.16 all my reports are getting this error: org.springframework.web.multipart.MultipartException: Failed to parse multipart servlet request; nested exception is org.apache.commons.fileupload.FileUploadException: Stream ended unexpectedly at org.springframework.web.multipart.commons.CommonsMultipartResolver.parseRequest(CommonsMultipartResolver.java:169) at org.springframework.web.multipart.commons.CommonsMultipartResolver.resolveMultipart(CommonsMultipartResolver.java:143)...
You can ignore this, looks like a user error. There were 2 copies of the report in the DB and after i deleted them and restarted art everything was fine.
This is Art 3.2
A user reported a problem to me today. I can recreate the problem Whenever I select Configure Reports I get the screen with a error box stating: An error occurred java.sql.SQLException: com.fasterxml.jackson.core.JsonParseException: Unrecognized token 'CHAR': was expecting ('true', 'false' or 'null')at [Source: CHAR(TIME,ISO) AS TIME; line: 1, column: 5] Query: SELECT * FROM ART_QUERIES AQ Parameters: [] The Art log shows the following: java.sql.SQLException: com.fasterxml.jackson.core.JsonParseException:...
ok thanks
I checked the logs and found nothing. Looks like tomcat came up fine and gave control to the web application and then nothing.
This is odd, i built a new tomcat instance based on production, put in the war file and started it up. Its been trying to initialize now for almost an hour and the deploying the art web application directory still is not complete. The last message from a successful run was art has finished in 189,338 ms This is really odd. Any ideas how to get this running again? Thanks, Ray
well now i recycled my production server and it wont get out of the Deploying web application directory /usr/local/tomcat/art8/webapps/art any thoughts?
yes, ArtRepositoryDB.lobs
yes it is.
OK, so i'm in the Squirrirrel SQL Client changing the CLOB's to LONGVARCHAR. I'm at the last one and I take an error. Any help would be appreciated. ALTER TABLE ART_QUERIES ALTER COLUMN REPORT_SOURCE LONGVARCHAR; and i get: Error: file input/output error in statement [ALTER TABLE ART_QUERIES ALTER COLUMN REPORT_SOURCE LONGVARCHAR] SQLState: S1000 ErrorCode: -452
ok, i'm confused. first you say clob columns were introduced in 3.1 and now you are saying there should not be any ?! And i have not created any clob files that i know of.
Yes, and here they are. PUBLIC.ART_QUERIES REPORT_SOURCE CLOB(1G) PUBLIC.ART_JOBS EXTRA_SCHEDULES CLOB(1G) HOLIDAYS CLOB(1G) PUBLIC.ART_JOB_SCHEDULES EXTRA_SCHEDULES CLOB(1G) HOLIDAYS CLOB(1G) PUBLIC.ART_ENCRYPTORS OPENPGP_PUBLIC_KEY_STRING CLOB(1G) PUBLIC.ART_HOLIDAYS HOLIDAY_DEFINITION CLOB(1G)
failing functions reports, jobs, configure reports, access rights, jobs, caches, connections, loggers working functions configure datasources, report groups, users, parameters, schedules
yes it is a HSQLDB database and yes there are columns defined as CLOB. I changed all CLOB's to LONGVARCHAR, restarted the server and it is still getting the error.
We use art as a reporting solution for computer performance and capacity planning. We access 6 remote databases with our data and have 541 reports. It is used by our performance team and capacitiy planners.
stack trace attached
I followed all the steps to upgrade from ART 3.1 to 3.2. After starting tomcat (everything looks ok), I fire up my brower, update the settings, and go to look at reports. I get an empty report list and the following is on my brower: An error occurred org.hsqldb.HsqlException: file input/output error I will attached the stack trace.
That worked great, thanks so much. All my dashboards are running again. So, should i go change all my date fields from varchar to date format now? Thanks, Ray
yes no change, still an empty chart.
I have attached the debug log.
yes you were right it was an earlier issue. I relogged in and generated the report and got the attached stack trace.
yes i found several stack traces all the same.
I made the changes ran the dashboard and the chart was produced but it had no data. When i ran the report separatley outside the dashboard it ran fine and it had data
after making the changes from varchar to date and the date format is blank I go to run the dashboard and when i pull up the report my dates are prepopulated as follows: From Date (mm/dd/yyyy) 2018-01-04 To Date (mm/dd/yyyy) 2018-01-04 i have have data yet for today so i run yesterdays with dates 2018-01-03 but the chart that is generated is empty. When i use the format per the label 01/03/2018 I get java.text.ParseException: Unparseable date: "01/03/2018"
My dates are data type varchar and I dont see a field called Date Format
The jsp file did not help (even recycled server), i will attach the stack trace.
Yes, they are: From Date (mm/dd/yyyy) To Date (mm/dd/yyyy) mvs system id Complex Name datasource
report source
stack trace
Since upgrading from art 2.5 to art 3.1 my dashboard reports are taking errors. I have created a small report with only 1 report and it still fails with: I can run all the reports fine as single reports but get errors when they are run in a dashboard. com.ibm.db2.jcc.am.SqlException: Invalid data conversion: JDBC Date format must be yyyy-mm-dd. I will attach the java stack trace and the sample report source.
OK, thanks.
Please add ALTER TABLE ART_QUERIES ADD MODIFY_PASSWORD VARCHAR(100); to 3.0.1_to_3.1.0.sql
That worked great. Problem solved. Thanks.
I went to the Datasource Lists report via Configure | Reports page, selected the More | Preview option and ran the report. No errors. I dont see any errors. See attached report. When i go to the Configure | Datasource and edit it i dont see any mention of DRLUSER. SELECT DATABASE_ID,NAME FROM ART_DATABASES order by name;
stack trace
Debug Log
I picked up the new ART 3.0 and installed it. Looks really good. The reports that work locally work fine. When I go to run a report that requires a JDBC connection I get an error. I reviewed the beta issues we had and set the datasources dynamic lov report and so it has 2 columns. But i am still getting this error. I will put the stack trace and debug logs as attachements. com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DRLUSER.ART_DATABASES, DRI...
well, i'm bad. I went back and looked again at the parms. And it was the same issue...
That worked great for some of the reports. The parameter in question was set to 4...
OK, so i went into the parms of the reports and there is no drilldown field on any...
one more screenshot
There are 5 parameters. See attachments.
I am getting errors with some of my reports that have drilldowns. When i execute...
Thanks for the help, i'll go set the logger off.
Thanks so much. I have attached screen shots with the directions you gave me but...
Its bigger than what i wanted to paste in here so i attached it as a text docume...
OK, so I am still confused. I can't find what you are looking for. Let me review...
I'm not quite sure where you want me to look. I ran a report and got this: ART -...
This lov list is static as i understand it. The values are coded in the ART tool...
OK, so i downloaded and installed beta8. On the reports that dont have a lov for...
I just installed the art 3.0 beta 7. whenever i try to access a report i am getting...
I just downloaded ART 3.0 beta 5 (upgrading from Art 2.5.1). I applied all the database...