sudden problem with query screen in Change 5.3.1
cmtodd
Suddenly yesterday we started having a problem with both the Query and Report screens not being able to be displayed properly, see the attached screen shot.
We have tried several things, including re-installing change (to a different directory/port leaving old install in place but disabled), but still get the same problem. So we don't believe it is a problem with any of the Change install files. So that leaves what else??
Could user (RDS) or Synergy data cause this problem?
How about a problem with a Synergy binary?
A change IT made to our server?
We're grasping as to why this is happening.
Server is Linux (Red Hat). The problem shows up in any browser we have tried (IE11, Firefox, Chrome)
TIA,
Todd
Sheehan, Richard F (US)
Todd,
I’m one version behind you (5.3) but I don’t believe that area has changed in your version. Based on your error, I’d check your configuration to see if the trend reports are in your wsconfig directory. In the user_framework.cfg you will find this line:
[CCM_PROBLEM][NAME]breakdown_trend[/NAME][MAIN_TEMPLATE]user_framework/chart_rpt.html[/MAIN_TEMPLATE][HDR_TEMPLATE]user_framework/common_minus_query_hdr.html[/HDR_TEMPLATE][IMG_TEMPLATE]user_framework/cs_chart_common_img.html[/IMG_TEMPLATE][FTR_TEMPLATE]user_framework/common_ftr.html[/FTR_TEMPLATE][ATTRS][/ATTRS][CUSTOM_WSLET]CSChartSingleDateTrend[/CUSTOM_WSLET][/CCM_PROBLEM]
I suspect one of the html report files is missing in your configuration (either chart_rpt.html or something that file uses). For example, that files lives here in my UNIX world:
…wsconfig/templates/pt/reports/user_framework/chart_rpt.html
Good Luck!
Rich
Richard F. Sheehan
Systems Admin Sr Prin
Enterprise Shared Services
BAE Systems, Inc.
T: 607.770.2897
|
M: 607.953.9424
|
E:
richard....@baesystems.com
1098 Clark Street, Endicott, NY, 13760, USA – Bldg. 46-2 C41
www.baesystems.com
Connect with
BAE Systems:
From: synergy...@googlegroups.com [mailto:synergy...@googlegroups.com]
On Behalf Of cmtodd
Sent: Thursday, January 12, 2017 8:05 AM
To: Synergy CM Tool <synergy...@googlegroups.com>
Subject: sudden problem with query screen in Change 5.3.1
***
WARNING
***
EXTERNAL EMAIL -- This message originates from outside our organization.
--
You received this message because you are subscribed to the Google Groups "Synergy CM Tool" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
synergy-cm-to...@googlegroups.com.
To post to this group, send email to
synergy...@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.
Gundolf.S...@continental-corporation.com
my colleague and CS expert said:
"I assume that is from the Reports package ... I am not sure what they mean by using the 5.3.1 for several years without modifying it?
I assume that they still have changed something in the process package or in the reports package.
Another hint would be to check in the reports package (configuration file first) the "breakdown_trend" report and check all related files/directories if there are still on the right place."
Wishing you much success.
Kind regards, Gundolf
Mit den besten Gruessen / Best regards /
Mes salutations distinguées /
Met vriendelijke groeten /
Multe salutari / Saludos / Atenciosamente /
Cu stimă / Pozdrawiam
Gundolf Schellhase
I IC RD SW PT
Continental Automotive GmbH
Philipsstraße 1, 35576 Wetzlar, Germany
Postfach/P.O.box 14 40, 35573 Wetzlar, Germany
Telefon/Phone: +49 6441 370-786
Telefax/Fax: +49 6441 37013-786
E-mail: mailto:Gundolf.S...@continental-corporation.com
http://www.continental-corporation.com
________________________________________________________________________
Continental Automotive GmbH, Vahrenwalder Str. 9, D-30165 Hannover
Vorsitzender des Aufsichtsrats/Chairman of the Supervisory Board: Helmut
Matschi
Geschaeftsfuehrer/Managing Director: Georg Sistermanns, Harald
Stuhlmann
Sitz der Gesellschaft/Registered Office: Hannover
Registergericht/Registered Court: Amtsgericht Hannover, HRB 59424,
USt.-ID-Nr./VAT-ID-No. DE814950663
________________________________________________________________________
Proprietary and confidential. Distribution only by express authority of
Continental AG or its subsidiaries.
--
You received this message because you are subscribed to the Google Groups
"Synergy CM Tool" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to synergy-cm-to...@googlegroups.com.
To post to this group, send email to synergy...@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool
.
For more options, visit https://groups.google.com/d/optout.[attachment
"change_query_error.png" deleted by Gundolf Schellhase/usr/cag]
Ed Taekema
Americas Services Leader
416-907-2993 (office) | 647 828-6141 (cell) | 845-491-4466 (fax)
E-mail: ed.ta...@ca.ibm.com
cmtodd
I mean we have not modified the install, or any global reports (thru report builder) for a very long time. Only user data and user created queries and reports.
Also, we tried a brand new install of Change and still have the problem. Presumably all files should be in place for the new install. I have verified that at least all of the direct references to other files in the definition of breakdown_trend exist in the templates folder.
We think we may have a handle on the cause (or at least a work around). If we connect Change to a different RDS, then the problem goes away. Of course, so does many user preference, saved queries, etc. Do you think it possible corrupted RDS data for the admin account (we use ccm_root) could cause our problem? We are thinking of just clearing out the RDS entry for this user.
TIA
Todd
Hello Todd,
my colleague and CS expert said:
"I assume that is from the Reports package ... I am not sure what they mean by using the 5.3.1 for several years without modifying it?
I assume that they still have changed something in the process package or in the reports package.
Another hint would be to check in the reports package (configuration file first) the "breakdown_trend" report and check all related files/directories if there are still on the right place."
Wishing you much success.
Kind regards, Gundolf
Mit den besten Gruessen / Best regards /
Mes salutations distinguées /
Met vriendelijke groeten /
Multe salutari / Saludos / Atenciosamente /
Cu stimă / Pozdrawiam
Gundolf Schellhase
I IC RD SW PT
Continental Automotive GmbH
Philipsstraße 1, 35576 Wetzlar, Germany
Postfach/P.O.box 14 40, 35573 Wetzlar, Germany
Telefon/Phone: +49 6441 370-786
Telefax/Fax: +49 6441 37013-786
To unsubscribe from this group and stop receiving emails from it, send an email to synergy-cm-tool+unsubscribe@googlegroups.com.
To post to this group, send email to synergy-cm-tool@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.[attachment "change_query_error.png" deleted by Gundolf Schellhase/usr/cag]
cmtodd
It happens for all users. So do you think this could be corrupted RDS entry for ccm_root? That is what I'm thinking now. (connecting to a different RDS works around the problem, but of course makes all user saved data go bye-bye).
TIA,
Todd
To unsubscribe from this group and stop receiving emails from it, send an email to synergy-cm-tool+unsubscribe@googlegroups.com.
To post to this group, send email to synergy-cm-tool@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.[attachment "change_query_error.png" deleted by Gundolf Schellhase/usr/cag]
Sheehan, Richard F (US)
Todd,
We had an issue with our LDAP related to user saved reports. In our case it was only impacting one user. I really don’t recall exactly what the user was seeing now (I lost all my notes during the flood). I think what we ended up doing to fix the problem was to delete that account and create a new one. If you suspect this is your ccm_root account, you could try that I suppose. You will lose anything ccm_root has stored in the LDAP. If you perform LDAP backups and you know when it was “good” versus when it went bad, you could restore the last good backup. That will impact anything anyone saved since then but that should be less of an issue then starting with a clean one. In our case, I did work with support on that issue so you might be able to have someone there pull that PMR. I just looked and I can’t access any PMRs older than 2014.
Again Good Luck!
Rich
Richard F. Sheehan
Systems Admin Sr Prin
Enterprise Shared Services
BAE Systems, Inc.
T: 607.770.2897
|
M: 607.953.9424
|
E:
richard....@baesystems.com
1098 Clark Street, Endicott, NY, 13760, USA – Bldg. 46-2 C41
www.baesystems.com
Connect with
BAE Systems:
From: synergy...@googlegroups.com [mailto:synergy...@googlegroups.com]
On Behalf Of cmtodd
Sent: Thursday, January 12, 2017 9:51 AM
To: Synergy CM Tool <synergy...@googlegroups.com>
Cc: Anca....@continental-corporation.com; Ed.Ta...@ca.ibm.com
Subject: Re: Antwort: sudden problem with query screen in Change 5.3.1
***
WARNING
***
EXTERNAL EMAIL -- This message originates from outside our organization.
Thanks Ed.
To unsubscribe from this group and stop receiving emails from it, send an email to
To post to this group, send email to
synergy...@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.[attachment "change_query_error.png" deleted by Gundolf Schellhase/usr/cag]
--
You received this message because you are subscribed to the Google Groups "Synergy CM Tool" group.
To unsubscribe from this group and stop receiving emails from it, send an email to synergy-cm-to...@googlegroups.com.
To post to this group, send email to synergy...@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.
Ed Taekema
It could certainly be a corruption of the shared data under CCM_ROOT ... that is where the shared queries reports etc are stored ... do you have a backup of rds that you could go back to?
Cheers,
Ed
________________________________________________________
Ed Taekema
Americas Services Leader
IBM Watson IOT Lab Services
416-907-2993 (phone) | 647-828-6141 (cell) | 845-491-4466 (fax)
"Sheehan, Richard F (US)" ---2017/01/12 10:33:59 AM---Todd, We had an issue with our LDAP related to user saved reports. In our case it was only impactin
cmtodd
We have already duplicated the problem with a test Change install, a test RDS, and a copy of the production RDS data. We then were able to fix the problem by deleting the ccm_root entries in RDS and restarting Change.
We are going to do the same for the production server soon to get users working. Then we can request the backup restore (to a diff location ;-) ) from IT and export/import the ccm_root data later.
Thanks for everyone's quick responses.
Thanks Ed, as always... YOU ROCK!! :-)
Todd
1098 Clark Street, Endicott, NY, 13760, USA – Bldg. 46-2 C41
www.baesystems.com
Connect with BAE Systems:
To unsubscribe from this group and stop receiving emails from it, send an email to synergy-cm-tool+unsubscribe@googlegroups.com.
To post to this group, send email to synergy-cm-tool@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.[attachment "change_query_error.png" deleted by Gundolf Schellhase/usr/cag]
--
You received this message because you are subscribed to the Google Groups "Synergy CM Tool" group.
To unsubscribe from this group and stop receiving emails from it, send an email to synergy-cm-to...@googlegroups.com.
To post to this group, send email to synergy...@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Synergy CM Tool" group.
To unsubscribe from this group and stop receiving emails from it, send an email to synergy-cm-tool+unsubscribe@googlegroups.com.
To post to this group, send email to synergy-cm-tool@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Synergy CM Tool" group.
To unsubscribe from this group and stop receiving emails from it, send an email to synergy-cm-tool+unsubscribe@googlegroups.com.
To post to this group, send email to synergy-cm-tool@googlegroups.com.
Visit this group at https://groups.google.com/group/synergy-cm-tool.
For more options, visit https://groups.google.com/d/optout.