by Roger·Comments Off on netstat -ano | findstr “:53”
Product:
Planning Analytics Workspace
Microsoft Windows 2022 server
Issue:
Check if port is used by docker or other process?
Solution:
On the PAW server login and start the CMD prompt;
Enter below to check if port 53 (default port for docker is used)
netstat -ano | findstr ":53"
the ‘LISTENING’ status means it’s in use, and the PID (Process ID) shows which application, which you then check with tasklist /fi “PID eq [PID_number]” to identify the service.
Ensure that all ports in paw.ps1 file is open in the local firewall on the PAW server to ensure smooth operation.
Then the user that is accessing the PAW environment, have not created a “picture” of himself, and above error will be in the log file WAproxy.log as long he does not have set a “picture” for his user. Solution is for the end user to add a picture to her login profile in PAW:
Click on you name in the top right corner and select “profile and settings” from the dropdown menu.
Now you have a small picture in PAW – and there should be less error in the log file.
When in PAW open a book, you have in the URL the ID of the book, like http://servername.domain.com/?perspective=dashboard&id=237dd67d-f35-40a5-95a3-5e76c6e8289
This ID can be found in the log file WAproxy.log under your PAW installations log folder. Then you can on the line with this book ID, see who have open it.
If you open WAproxy.log file in Notepad++ and search in file for all occurrence of the text: c/v2/content/dashboard/
You will get a list of all books that have been open and by who – the login ID will be last on the line.
More Information:
404 – page or data not found
401 – unauthenticated, you have not logged in to access this page or data
200 – success – page or data loaded fine
304 – you already have the page cached in your web browser, no need to send it again
500 – A generic error message, given when an unexpected condition was encountered. Read the WAproxy file for more information and search IBM web site for an explanation.
Wireshark: Open Wireshark, choose the network interface you want to monitor, and start the capture. You can use capture filters to narrow down the traffic you see (e.g., by IP address or port). Stop the capture and save the results in a .pcap file for later analysis.
Fiddler: This tool is excellent for capturing and inspecting both HTTP and HTTPS traffic from any browser or application. It allows you to filter, save, and replay traffic sessions.
tcpdump: A command-line utility that captures raw packets. You can specify an interface (-i) and write the output to a file (-w). For example, tcpdump -i wlan0 -w capture.pcap would capture traffic from the wlan0 interface to a file named capture.pcap
You can also use the network tool built inside the web browser, they save the collected data to a HAR file.
HAR files (“Http ARchive”) are a JSON-formatted archive file format for logging a web browser’s interaction with a site.
Typically, they are useful in troubleshooting performance problems (and errors) when using web-based software (such as PAW).
The steps vary, depending on the web browser that the user is using.
Chrome
1. Launch Google Chrome.
2. In Chrome, go to the page where you are experiencing trouble
3. Select the Chrome menu (⋮) at the top-right of your browser window, then select More Tools > Developer Tools.
4. The Developer Tools will open as a docked panel at the side or bottom of Chrome. Click on the Network tab.
5. Tick/select the option Preserve log (see below):
6. The recording should autostart and you will see a red circle at the top left of the Network tab (see above).
If not, click the black circle, to start recording activity in your browser.
7. Refresh the web page that you are on
– Perform the task which is causing the issue
– The goal is to reproduce the problem you’ve been experiencing while Google Chrome is recording activity.
8. Once you have reproduced the problem (while recording), right-click within the Network tab and click Save as HAR with Content to save a copy of the activity that you recorded:
9. Save the HAR file somewhere convenient.
10. Now click the Console tab and right-click anywhere in the console log. Select the popup option “Save as…” and name the log file something sensible:
11. Close the developer panel.
12. Typically, the customer will now upload the two files (especially the HAR file) into their support case.
Firefox
1. Launch Firefox.
2. In Firefox, go to the page where you are experiencing trouble.
3. Select the Firefox menu (Three horizontal parallel lines) at the top-right of your browser window, then select Developer > Network.
4. The Developer Network Tools will open as a docked panel at the side or bottom of Firefox. Click on the Network tab.
– Before starting the capture, be sure to enable the setting: Enable persistent logs in the Toolbox Options > Common Preferences (click on gear icon on the Toolbox toolbar to open the Toolbox Options pane)
– Click on the Network tab after setting the option.
5. The recording will autostart once you start performing actions in the browser.
6. Refresh the web page that you are on
– Perform the task which is causing the issue
– The goal is to reproduce the problem you’ve been experiencing while Firefox is recording activity.
7. Once you have reproduced the issue and you see that all of the actions have been generated in the Developer Network Panel (this should just take a few seconds), right-click anywhere under the “File” column and click on “Save All as Har”
8. Save the HAR file somewhere convenient and close the developer panel.
9. Typically, the customer will now upload the HAR file into their support case.Internet Explorer (IE)
We shall use Microsoft F12 Developer Tools and the Network Tool to capture the browser headers. Then export the captured traffic as HAR file (or XML if using older version of IE).
1. Launch Microsoft Internet Explorer.
2. Press the F12 key on your keyboard. This should open the Developer Tools panel in IE. If not, find it on the browser menu: F12 Developer Tools
3. In the Developer Tools panel, click the Network panel and then deselect the Clear entries on navigate option. (on by default).
4. Click the Network panel/button and then the Start Capturing button (or press Ctrl + E). Note: the icon looks like a green triangle
5. Click the IE Refresh button. The goal is to reproduce the problem you’ve been experiencing while IE is recording activity
6. The Developer Tool panel should now show a list of the URLs that are included in the page you have in your browser.
7. Click the Stop button when the issue has been reproduced (or press Ctrl + E). Note: the icon looks like a red square
8. Click the Export captured traffic icon and save the file somewhere convenient (or press Ctrl + S). Note: the icon looks like a floppy disk.
9. Typically, the customer will now upload the HAR file into their support case.
10. Click on the Console tab and look for any errors/warnings reported. If errors are shown, please right-click on the console errors and select Copy all or send a screenshot of them.
11. Close the Developer Tools panel.
by Roger·Comments Off on How add the TM1 name instance to the toolbar
Product:
Planning Analytics 2.1.14 Tm1web
Microsoft Windows 2022 server
Issue:
In TM1WEB how see what application i have logged in to?
Solution:
Add the TM1 instance name in the toolbar with you name.
Go to Tm1 web server
Go to folder D:\Program files\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\configuration
Open file tm1web_config.xml
Change <add key=”TM1DatabaseLabel” value=”Y” />
Save the file
You do not need to restart the TM1WEB service (IBM Planning Analytics Spreadsheet Services) to see the effect.
Only logout and in to TM1WEB.
http://servername.domain.com:9510/tm1web
More Information:
<!– If “Y” or “1” is specified, then the name of the logged in Database will appear next to the logged in user name in the top right of TM1 Web. –>
<add key=”TM1DatabaseLabel” value=”Y” />
Planning Analytics 2.1.11
Microsoft Windows 2022 server
Issue:
How many element in a dimension subset?
Solution:
Use the function SubsetMDXSet to get the number of elements in the selection, it will also convert the MDX subset to a static subset.
SubsetMDXSet applies a specified MDX expression to a public or temporary subset.
If the passed MDX expression is valid, the specified subset is saved as a dynamic subset defined by the MDX expression.
If the passed MDX expression is an empty string, the subset is converted to a static subset that contains the elements that are in place when SubsetMDXSet is executed.
The SubsetMDXSet returns the number of elements that the subset contains.
In below example the subset becomes static as we use ” as parameter.
We can use the number of elements, to count them and add them to a new dimension, with a total element first.
DimensionElementInsertDirect( tDim, '', 'Total', 'C');
sSubset = 'temp_Account';
sMDX = '{TM1FILTERBYLEVEL(TM1SUBSETALL([Account]) , 0)}';
SubsetCreatebyMDX(sSubset, sMDX, 1 );
vNumElems = SubsetMDXSet( tDim, sSubset, '' );
i = 1;
while (i<=vNumElems);
vElem = SubsetGetElementName( tDim,sSubset, i );
DimensionElementComponentAdd( tDim, 'Total',vElem, 1 );
i = i +1;
end;
Sometimes we can not login, but it work if we start a different web browser on your computer. Try EDGE instead of CROME.
Note that PAW and TM1WEB looks like it use different whys to handle cookies at login.
CA may time out and throw one of the following errors:
Unexpected Server Response
HTTP Error 431
Unable to Load Requested View
Cannot read properties of undefined (reading ‘perspective’)
DPR-ERR-2107 The User Capabilities Cache cookie cannot be decoded.
Solution:
Clear cache and cookies from the affected browser. See KB 15 (Michigan State University) for details.
Close completely out of all browser windows.
Open an incognito/InPrivate browsing window and use that to access Cognos. See KB 1203 (Michigan State University) for details.
Check you go to correct start page ( https://XXXXX.planning-analytics.cloud.ibm.com ) – exchange with your local server name.
Check that your local network is working – try a different physical location for your laptop.
There can be other solutions or explanations of this errors – hopefully you can find them at IBM site.
How to retrieve the content of the CAM_passport and userSessionID from cookie?
In Browser window after you log in to the Cognos Connection Portal type any of the following in the address bar of the browser:
Or maybe have a look in your user directory under “C:\Users\yourname\AppData\Local\Microsoft\Edge\User Data\Default” or “C:\Users\yourname\AppData\Local\Google\Chrome\User Data\Default” .. or where the files are stored in modern browsers.
Easier to view cookies in Chrome, perform the following steps:
Open Chrome settings. Right-click on your browser window.
Choose Inspect to enter the Chrome Developer Tools.
Choose the Applications tab. Depending on the size of your screen, you may need to expand your tab options at the top by clicking on the >> symbol:
Open application.
Under the Storage tab, select Cookies to view cookies in Chrome.
You will see all the available websites. Select the website you want to see cookies in Chrome.
Check the domain column, if you have different values here for same cam_passport (cookie) then you can get above errors. Should only be ONE domain name for the same cookie name.
Name. The cookie’s name.
Value. The cookie’s value.
Domain. If the domain name corresponds with the website you are browsing, it means that these cookies are First-party cookies. If the domain name is different- these cookies are third-party cookies.
Path. The URL that must exist in the requested URL in order to send the Cookie header.
Expires / Max-Age. The cookie’s expiration date or maximum age. This field shows which are session cookies and which are persistent cookies, that operate for a certain duration of time.
Size. The cookie’s size, in bytes.
HttpOnly. If true, this means that it is a HTTP cookie. JavaScript modification is not allowed.
Secure. If true, this means that the cookie is sent to the server only over a secure, HTTPS connection.
SameSite. The SameSite cookie attribute is used by browsers to allow or block cookies based on attribute. It could contain Strict or Lax SameSite attributes.
Partition Key. A cookie’s partition key is the scheme and registrable domain of the top-level URL the browser was visiting at the start of the request to the endpoint that set the cookie.
Priority. It is used with deprecated cookie priority attribute. Could contain Low, Medium (default), or High priority.
Issue:
What anti-virus software should i use on my old laptop?
Suggested solution:
Windows Defender is good, but when there are no more updates, you can consider to use a separate Anti-Virus software product.
You have to yourself decide what to use (and if you need it) as the software market for anti-virus program is lucrative, program that was good for 10 years ago is maybe not the best today.
Consider:
Is the software easy to understand for me? Can i setup schedule scans in a easy way?
What is the price the second year? Most software will give you a 50% discount the first year. Check if you can get a family price for 3-5 computers. Review sites have often links to good offers.
Does the software take a lot of CPU when running or does it do the scan in the “cloud” ? Check more than one review to see if the program will slow down your PC.
Check more than one review of the software – most top teen listings are only trying to sell you a special anti-virus software where they get most money from.
Do you trust the company behind the program? Check WIKI pages about what country the software comes from.
As of January 2006, ZoneAlarm was reportedly[6] sending data to the company’s servers in a covert fashion. A developer dismissed allegations that ZoneAlarm was spying on its clients, saying that it was an issue related to software updates and that it would be fixed.[7]
In December 2007, a browser toolbar was shipped with ZoneAlarm as an opt-out, which was not well received.[8] This was removed in later versions of the software.
On September 2, 2010, the free version of ZoneAlarm started showing a “Global Virus Alert” popup as a scareware tactic to get users to switch to their paid security suite.[9] The popup was turned off by ZoneAlarm marketing team after an uproar from disgruntled users, many of whom uninstalled the software.[10][11]
These program have a free version (that you can test):
We tested the Bitdefender windows version on Windows 10.
We run a deep scan, and it found things in old TM1 files, version 2.1.5, Trojan.GenericKD is Windows-only malware, as far as I know, so it’s highly likely that these detection’s are false positives, as it looks like many anti-virus software can find them in different files.
If there where issues, this are solved now. IBM sends out updates regularly. We checked the latest version PAL 2.1.14, and there where no issues there.
(It looks like the Bit-defender can not scan ZIP files larger than 2 GB)
We upgrade Bitdefender to PLUS version in hope the firewall should be part of that deal.
But firewall was not part of the PLUS version. We got the VPN function, but you can not choose what country you will be using. We need to upgrade again to get firewall…
The company change the offering every year, so the package you have the first year may be something different the next year. If you stop your automatic subscription, then the bitdefender program stops working when the subscription ends. Malwarebytes have a different solution.
Passwords manager is better to use separate program like:
Before you decide, search the internet for zonealarm issues…