{"id":587,"date":"2016-06-12T19:37:08","date_gmt":"2016-06-12T19:37:08","guid":{"rendered":"http:\/\/www.logicons.co.nz\/TLPWiki\/?page_id=587"},"modified":"2017-07-05T22:52:24","modified_gmt":"2017-07-05T22:52:24","slug":"faq","status":"publish","type":"page","link":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/faq\/","title":{"rendered":"FAQ"},"content":{"rendered":"<p><strong>Data appears in TLP but not in SQL reports<\/strong><\/p>\n<p><em>This is usually an issue of &#8216;bad data&#8217;, some records are not allowing the database to sync with SQL. Thus, not all the data is appearing in your reports. Currently you will need to contact Logistics Consultants support and they will be able to help with your data.<\/em><\/p>\n<p><strong>Backup script not running<\/strong><\/p>\n<p>When attempting to run a backup (eg before server upgrade or significant data entry) the following is seen at the DOS prompt.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770\" src=\"http:\/\/www.logicons.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/MissFile.png\" alt=\"MissFile\" width=\"676\" height=\"340\" srcset=\"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/MissFile.png 676w, https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/MissFile-300x151.png 300w, https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/MissFile-150x75.png 150w\" sizes=\"auto, (max-width: 676px) 100vw, 676px\" \/><\/p>\n<ol>\n<li><em>Ensure you are using the latest backup script version. (all scripts are updated following a TLP upgrade)<\/em><\/li>\n<li><em>Ensure that the root.tar.gz file is in webapps<\/em><\/li>\n<li><em>Ensure that c:\\Mongodb\\bin has been added to the system path<\/em><\/li>\n<\/ol>\n<p><strong>I see different results when I use Chrome, IE or Firefox browser\u00a0<\/strong>The only browser TLP supports is Chrome. Other browers will work for the majority of functionality but do give the odd unexpected result. When viewing SQL reports IE is recommended.<\/p>\n<p><strong>I see this error when I open TLP in my browser<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-837\" src=\"http:\/\/www.logicons.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/Browser.png\" alt=\"Browser\" width=\"672\" height=\"184\" srcset=\"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/Browser.png 672w, https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/Browser-300x82.png 300w, https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-content\/uploads\/2016\/06\/Browser-150x41.png 150w\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" \/><\/p>\n<p>The application was launched with the full URL. TLP simply needs to directed at the .war file on the web server and will complete the URL itself. So in the browser simply type or bookmark <em>http:\/\/&lt;server&gt;&lt;port&gt;\/transport<\/em><\/p>\n<p><strong>Cannot restore a database after I backed it up using the scripts<\/strong><\/p>\n<p>There have been times when the mongo database corrupts when we try to restore a backup. Therefore once a backup has been taken it may be necessary to &#8216;drop&#8217; the old database before running the restore script to produce the new. The easiest way to do this is within Mongo from the command line issue the mongo command to drop the database (db.dropDatabase()) and then run the restore script.<\/p>\n<p><strong>I keep getting logged out of TLP<\/strong><\/p>\n<p>TLP uses session IDs based on the host (server) of your TLP. So for example, if you have both a &#8216;Live&#8217; and &#8216;Test&#8217; system running on the same server and log in to both using the same login then you may log yourself out of one when you log onto the other. The way to resolve this is to set up a\u00a0reverse proxy<\/p>\n<p>Set up the hosts something like this &#8211; \u00a0request llive.tlp.something.com\u00a0(default port 80) and get directed to <a href=\"http:\/\/spiky.com\">something.com<\/a>:8099. This will probably need to be done by your network administrator.<\/p>\n<p><strong>I can download the TOBY module but it will not install on my device<\/strong><\/p>\n<p>There is a known issue when trying to install TOBY onto an Android 6 device &#8211; only devices that have currently been reported with the issue. Although the module &#8220;downloads&#8221; successfully from the website it does not install. The user is presented with a &#8216;App not installed&#8217; message.<\/p>\n<p>The solution is to edit the downloaded APK file. The file needs editing to &#8216;internal&#8217; installation and not the default setting. To achieve this you will need to download an APK editor from Google play and then edit the apk file. Once you have edited\/saved the apk file then you can install the app.<\/p>\n<p>This youtube video shows the process clearly.\u00a0<a href=\"https:\/\/www.youtube.com\/watch?v=xAwzKXg-00c\">https:\/\/www.youtube.com\/watch?v=xAwzKXg-00c<\/a><\/p>\n<p>This is only an interim fix, the development team are working on fixing the apk file at source.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data appears in TLP but not in SQL reports This is usually an issue of &#8216;bad data&#8217;, some records are not allowing the database to sync with SQL.\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-587","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/pages\/587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/comments?post=587"}],"version-history":[{"count":10,"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/pages\/587\/revisions"}],"predecessor-version":[{"id":1003,"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/pages\/587\/revisions\/1003"}],"wp:attachment":[{"href":"https:\/\/www.tlpsystems.co.nz\/TLPWiki\/wp-json\/wp\/v2\/media?parent=587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}