help with debuggin PxWeb SavedQuery database

[Tadej Obrstar]

Hello all,

We are updating our PxWeb to version 2022. Everything worked fined in the test environment, but in the production saved queries to database don’t work. They worked with the same connection string on the old version in production (same server) and on the new version in the test environment. Looking at the logs I can’t find any useful information. Saving to file works fine.

Could you point me in the right direction on how to debug this. Is there someway I can see in the logs where the process fails? The only error I get is from the WebUI when I click on save your query “Failed to save the query”.

Kind regards,

Tadej

[stefan...@stadshuset.goteborg.se]

Hello, I have a similar issue on two installations, both with IIS 10:
Version 2022v1:
Everything in the dialogue box to save the query works, but it seems like the query is not always saved.
Sometimes I can see the query on the server but the link  does not work, I get an error from the WebUI as Tadej.

Version 2023v1: 
Pressing 'Copy' in the dialogue box copies the link, at the same time the dialogue box dissapears. The link is not copied.
Query is not saved on the server.

//Stefan

[Petros Likidis]

Hi Tadej,

From your description this sounds like something in the communication with the database. 

If you are using Microsoft SQL Server to store the saved queries then there is the possibility that the assembly bindings section is wrong in web.config. That is if you use your old web.config. If so copy the assembly binding section from the web.config coming from the new PxWeb installation folder and replace it in your existing one.

If that does not help, try to temporarily set the log level in web.config to DEBUG and see if you get any message in web.config.

Kind regards

Petros

--
You received this message because you are subscribed to the Google Groups "pcaxis" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pcaxis+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/d5da0403-a76a-4330-a055-aa82b6992faan%40googlegroups.com.

[Petros Likidis]

Hi Stefan,

This sounds really strange. Do you get any error messages in the log?

Kind regards

Petros

--

You received this message because you are subscribed to the Google Groups "pcaxis" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pcaxis+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/16d20bd2-9e7d-4427-92a6-8e338880f94fn%40googlegroups.com.

[Tadej Obrstar]

I figured out what was going while trying to read a saved query from the database which actually returned an error unlike saving the query. PxWeb had trouble loading SNI.dll which helped me solve the problem by installing Microsoft Visual C++ 2015-2019 Redistributable which was missing on the production server.

[stefan...@stadshuset.goteborg.se]

First, the query (as file) is saved properly. It was an update issue with the FTP application.

As I said, when i press 'Copy' the dialogue box dissapears an the link is not copied. That is regardless if I choose it to be shown on screen or download to a file.
Save the query as to be shown on screen: If I copy the link manually and try to use it, it returns the px-web error page.

Save the query as to be downloaded to file:  If I copy the link manually and try to use it, It works, file is downloaded

Example link that does not work (show on screen) : http://pxweb.goteborg.se/sq/a1e2f076-594c-4298-950f-97ae6c189739

Example link that works (download as Excel):http://pxweb.goteborg.se/sq/1ee32498-0c79-474a-817b-f6b6bcd2806e (download as px-file also works)

PART OF PXWEB.LOG:

2024-09-13 14:05:03,702 [28] INFO  PXWeb.DatabasesSettings - Loading of PX databases ended
2024-09-13 14:05:04,297 [28] INFO  PCAxis.Paxiom.Localization.PxResourceReader - Loading language from D:\IIScontent\PXWeb.org\Resources\Languages\pxlang.xml
2024-09-13 14:07:59,337 [29] ERROR PXWeb.Modules.PXWebHttpModule - PX-Web Application Error ---> Offending URL: http://pxweb.goteborg.se/sq/Default.aspx?loadedQueryId=a1e2f076-594c-4298-950f-97ae6c189739&timeType=top&timeValue=3 -- Source: PXWeb -- Message: HTTP/1.1 404 Not Found -- Stack trace:    at PXWeb.SavedQueryHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2024-09-13 14:07:59,337 [29] ERROR Global - System.Web.HttpException (0x80004005): HTTP/1.1 404 Not Found
   at PXWeb.SavedQueryHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2024-09-13 14:07:59,778 [20] ERROR PXWeb.Modules.PXWebHttpModule - PX-Web Application Error ---> Offending URL: http://pxweb.goteborg.se/sq/Default.aspx?loadedQueryId=a1e2f076-594c-4298-950f-97ae6c189739&timeType=top&timeValue=3 -- Source: PXWeb -- Message: HTTP/1.1 404 Not Found -- Stack trace:    at PXWeb.SavedQueryHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2024-09-13 14:07:59,778 [20] ERROR Global - System.Web.HttpException (0x80004005): HTTP/1.1 404 Not Found
   at PXWeb.SavedQueryHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

[Petros Likidis]

Hi,

Tadej, I am glad that you managed to solve your problem!

Stefan, I have heard that there is a issue it the copy button when the site is running i plain http and not with TLS (https). It is tome type of security issue not allowing scripts to modify the clipboard. 

I am assuming that the error messages are connected to the first saved query. It looks like it can´t find the saved query on disk. You mention something about an issue in an FTP application. Could it be that anouther process have moved och deleted the file?

Kind regards

Petros

[Lars Pedersen]

Hi,

 

On our internal pxweb installation chart rendering is extremely slow. On the external (official site) server, which should be a technical mirror – there is no problem.

 

Can anyone offer some advice, on where to look?

 

We are running pxweb 2023v1

 

J LarsP

[Lars Pedersen]

 

On the internal server it takes 22 seconds before ChartHandler.ashx ver=06%...

Is reported in logfile. On the external it is milliseconds

 

What does ver=06 means and why is it ver=07 on the external?

 

Can I have some files from older pxweb 2021v1 on the server?

 

 

Internal server

2024-09-16 07:53:49 10.240.76.83 GET /Resources/Images/svg/NavigationFlow/Ste …

2024-09-16 07:54:11 10.240.76.83 GET /ChartHandler.ashx ver=06%...

 

External server

2024-09-16 08:05:31 10.240.76.82 GET /Resources/Images/svg/NavigationFlow/Ste…

2024-09-16 08:05:31 10.240.76.82 GET /ChartHandler.ashx ver=07%...

 

Hope for some help with this

 

J LarsP

[Hans Baumgartner]

Hi,

- You did a IISREST /STOP before you did a version upgrade?
- Did you update the .Net Framework to 4.8
- Did you download the latest 2023v1 version from SCB?
- Sometimes SCB does the big No No and updates the production version on their site
  without any change in the distribution number (example 2021V1).

What you say does not make any sense, so just reinstall the 2023V1 (latest version)
There has to be a logical reason for your problem.

Our latest version 2023V1
https://pxdata.stat.fi/pxweb/ping/
<ping>

<version>23.0.0.26013</version>

</ping>

Your latest version:
https://bank.stat.gl/ping/

<ping>

<version>23.0.0.26013</version>

</ping>

So we are both running the same version:
https://pxdata.stat.fi/PxWeb/pxweb/en/StatFin/

Hans

Lähettäjä: 'Lars Pedersen' via pcaxis <pca...@googlegroups.com>
Lähetetty: maanantai 16. syyskuuta 2024 12.35
Vastaanottaja: 'pcaxis' <pca...@googlegroups.com>
Aihe: added log file observation : where to look, when chart creation is very, very slow?

--

You received this message because you are subscribed to the Google Groups "pcaxis" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pcaxis+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/204548e83c2c4114bd4b955fa5bcb374%40stat.gl.

[Lars Pedersen]

Thank you so much Hans, for this check list

 

I’ll walk through and let you know, how it goes

 

J

To view this discussion on the web visit https://groups.google.com/d/msgid/pcaxis/AS4PR10MB604045F8BA0C1604E93970BE91622%40AS4PR10MB6040.EURPRD10.PROD.OUTLOOK.COM.