Error : While fetching the POS articles - "Heterogenous Query......"

SpeedNet :- Collection of Articles - My Office

Error : while fetching the POS articles - "Heterogenous Query......"

Run the EXL file in Script Tool.exe for POSPCC database.

(Script Tool.Exe is available in SpeedNet Solutions)

FetchFromCounter_HeterogenousQuery_Solution

Revised MNOP Script dated 18.06.2012

Revised MNOP Script dated 18.06.2012 download link:

ftp://ftp.ptcinfo.org/MNOP_Hubs_Upda..._POS_SpeedNet/

Updates for Speednet Virtual Scanning

To Provide virtual scanning for all Speed Post articles including UID upto 25 days from the date of receipt of messages from Central Server, CEPT, Mysore has released exl file..

ftp://ftp.ptcinfo.org/SpeedNet/

Release of Revised MNOP Script dtd 07/05/2012

Release of Revised MNOP Script  dtd 07/05/2012 is available in the following PTC link

ftp://ftp.ptcinfo.org/MNOP_Hubs_UpdationScripts_POS_SpeedNet/

Release of Revised MNOP Script ( dtd 01/05/2012)

Release of Revised MNOP Script (dtd 01/05/2012) is available in the following link


ftp://ftp.ptcinfo.org/MNOP_Hubs_UpdationScripts_POS_SpeedNet/

SpeedNet 3.1.2 (15/12/2011) Patch-3 dated 26/04/2012

THIS PATCH IS A MUST TO BE EXECUTED AT ALL OFFICES using BNPL andCollection Agent Module. 

(To update the Base Value of Speed post tariff for One India - One Rate Scheme in BNPL and CA Module)

NOTE: There is already provision in the SpeedNet Module for revising the latest Rate of the Service Tax
under the Supervisor Login:
BNPL--> BNPL Configuration --> Miscellaneous Charges --> Service Tax option.

All offices have to add the entry for new Service Tax rate of 12% effective from 01.04.2012.

This patch is released to provide the following:
================================

1. Due to the increase in Service Tax Rate - the Base value of Speed post tariff for One India - One Rate Scheme in BNPL is revised as follows.

                     Old Base Value           New Base Value
                         --------------                 --------------

Local                         10.88                 10.67

One India rate           22.67                   22.24

2. Enhancement of Customer Agreement period from one year to two year as per BD & M Dte, N Delhi
lr.no. 57-02/2010-BD&MD dated 13.04.2012.

3. Please read the specific instructions detailed at Step III below for changes in theCollection Agent Module.

Other than BNPL Provision:
===================

Provision is made to close FLAT RATE BOX in EPP Bags with specific Barcode prefix of "CF" for such bag.
(As per the FRB Operational Manual, separate EPP bags containing FRBs have to be closed with CF barcode only)

Flexibility is provided to close EPP Bag containing FRBs with X series/CF series barcode until it is
confirmed that all Circles have procured CF barcodes for EPP Bags containing FRBs.

Patch-3 Release for Speednet_3.1.2_15122011 release - contains 2 folders.
-------------------------------------------------------------------------

1. SpeedNet3.1.2_15122011_DBScript_26042012
2. SpeedNet3.1.2_15122011_ClientPatch_26042012

Pre-Requisite:
---------------
Speednet 3.1.2 should have been upgraded with the latest rlease of SpeedNet on 15/12/2011
( ftp://ftp.ptcinfo.org/SpeedNet/speednet3.1.2_15122011/)

Those who are using speednet3.1.2_15122011 but not used the Patch2, can directly upgrade with Patch3


I: Upgrade the DB first with DBscript file.
============================

1. Take Full Backup of POSPCC DB

2. Execute the DB Script through Script Tool.exe.

3. On Successful upgradation of DB, go to Step II.

II. Now copy the Dlls, SNT and EXE:
===========================

1. Copy all the Dlls , SNT and the Exe file from the folder and copy the same
into C:\Program Files\SpeedNet folder ( default installation folder)

NOTE: There is also CollectionAgent.exe for which read step III.

2. Register all the Dlls.

3. Execute the BNPLDataCorrection.exe file which is already there in SpeedNet folder.

Now you may please run speedNet and confirm successful login.

III. For Offices having Collection Agents:
=============================

1. After doing the upgradation for Patch-3, generate Configuration File for eachCollection Agent and send
it to CA for updation in his/her system.

2. Along with the Configuration file, send the latest CollectionAgent.exe file included in the Patch-3 release
and ask the CAs to overwrite the CollectionAgent.exe file in their systems
(default path: C:\Program Files\Speednet Collection Agent\).


Problems if any may please be emailed to support@ceptmysore.net with Subject as
SpeedNet Patch-3

Click HERE to download the patch

Register Speednet DLL files easily

If your Installation Directory of Speednet is as below:

C:\Program Files\Speednet

Then the following DLLs can be registered through this RegDLL Tool. (After downloading pl change the file extn as exe)

BNPLDLL.dll
CollectionAgent.dll
EMSDelivery.dll
SpeedNetLib.dll

(SpeedNet_3.1.2(15122011) Patch-1 dated 28/03/2012)


Download

Courtesy : http://srfix.blogspot.in

Update SpeedNet 3.1.2---ATTENTION OFFICES WHICH HAVE ALREADY USED PATCH-1:

ATTENTION OFFICES WHICH HAVE ALREADY USED PATCH-1:

PATCH-2 dated 31/03/2012 IS A MUST FOR ALL OFFICES WHiCH HAVE DOWNLOADED AND UPDATED PATCH 1 dated 28/03/2012.

You may please update SpeedNet3.1.2_15122011_Client Patch_31032012 into Speed net Client
installation Folder.

DB updation file is same for Patch1 and 2.

Those offices which have not yet used the Patch-1 can directly use this Patch-2.


Download from PTC FTP

SpeedNet 3.1.2 (15122011) Patch-1 dated 28/03/2012

THIS PATCH IS A MUST TO BE EXECUTED AT ALL OFFICES WHO DO THE BNPL BILLING THROUGH SPEEDNET.

This patch is released to provide the foloiwng solutions.

1. This patch will fix the bug in BNPL Billing.

If this patch is not applied then there will be difference in the actual bill amount to
that of the Bill Amount generated in the SpeedNet from April 2012 Bill onwards.

2. Invalid Use of Null error in Receipts/Close TB/Dispatch Bags option Fixed
with a Message To fix the problem locally.


3. Error - "Data Not Saved" while Opening UID Bag is fixed

4. My Office Details - Pin Code View has been corrected for Offices whose Pin Codes are
changed.

5. SpeedNet Manifest offline printing problem solved.

6. It includes the earlier DBPatch solution -for not fetching the InsRPs from POS to SpeedNet
through Network Fetch.

SPEEDNET3.1.2_Patch1Release_28032012.zip - contains 2 folders.

1. SpeedNet3.1.2_15122011_DBScript_28032012
2. SpeedNet3.1.2_15122011_ClientPatch_28032012

Pre-Requisite:

Speednet 3.1.2 should have been upgraded with the latest rlease of SpeedNet on 15/12/2011
( ftp://ftp.ptcinfo.org/SpeedNet/speednet3.1.2_15122011/)

I: Upgrade the DB first with DBscript file.

1. Take Full Backup of POSPCC DB
2. Execute the DB Script through Script Tool.exe
3. On Successful upgradation of DB, go to Step II.

II. Now copy the Dlls and EXE:

1.Copying Dlls and Exe file into SpeedNet Client Installation Path:
------------------------------------------------------------------

2. Copy all the Dlls and the Exe file from the folder and copy the same
into C:\Program Files\SpeedNet folder ( default installation folder)

3. Register all the Dlls.

Now you may please run the speedNet and confirm the successful login.

Problems if any may please be emailed to support@ceptmysore.net with Subject as SpeedNet Patch-1 28032012.

Download

Release of revised MNOP Script (dated 05.03.2012)

Release of Revised MNOP Script

It is decided to keep both POS and SpeedNet MNOP Updation Script at a single point download. This script has to be used at all the offices using POS and SpeedNet.
Based on the latest Sorting Extract / Orders received from the Directorate and IC Hub Data received from Circles, the Revised MNOP Script is released and the details of the releases are as follows.
This script will contain the entire Hub Master data as per the requirement /modifications - including all the previous revisions. This document shows only the latest revisions.
Click on the following link to download

ftp://ftp.ptcinfo.org/MNOP_Hubs_UpdationScripts_POS_SpeedNet/

Release of Revised MNOP Script ( Dated 23.02.2012 )

Release of Revised MNOP Script

It is decided to keep both POS and SpeedNet MNOP Updation Script at a single point download. This script has to be used at all the offices using POS and SpeedNet.

Based on the latest Sorting Extract / Orders received from the Directorate and IC Hub Data received from Circles, the Revised MNOP Script is released and the details of the releases are as follows.

This script will contain the entire Hub Master data as per the requirement /modifications - including all the previous revisions. This document shows only the latest revisions. 

Source : ftp://ftp.ptcinfo.org/MNOP_Hubs_UpdationScripts_POS_SpeedNet/

Revised MNOP Script dated15.02.2012 had been released

Release of Revised MNOP Script  dated15.02.2012

It is decided to keep both POS and SpeedNet MNOP Updation Script at a single point download. This script has to be used at all the offices using POS and SpeedNet.

Based on the latest Sorting Extract / Orders received from the Directorate and IC Hub Data received from Circles, the Revised MNOP Script is released and the details of the releases are as follows.

This script will contain the entire Hub Master data as per the requirement /modifications - including all the previous revisions. This document shows only the latest revisions.

Source : ftp://ftp.ptcinfo.org/MNOP_Hubs_UpdationScripts_POS_SpeedNet/

Release of Revised MNOP Script ( dtd 08/02/2012 )

Release of Revised MNOP Script

It is decided to keep both POS and SpeedNet MNOP Updation Script at a single point download. This script has to be used at all the offices using POS and SpeedNet.

Based on the latest Sorting Extract / Orders received from the Directorate and IC Hub Data received from Circles, the Revised MNOP Script is released and the details of the releases are as follows.

This script will contain the entire Hub Master data as per the requirement /modifications - including all the previous revisions. This document shows only the latest revisions.

Source & Download
ftp://ftp.ptcinfo.org/MNOP_Hubs_UpdationScripts_POS_SpeedNet/

SpeedNet Problems and Solutions

Trouble Shooting in SpeedNet package:

Trouble Shooting in SpeedNet package:

 The questions /problems in this FAQ is arranged in the order of :

· Installation

· Configuration

· Login

· Supervisory options

· Operator options

· MIS

(You may also use Find option (Ctrl+F) with error description to easily locate the solution in this post)

Problem	Solution
Installation
While installing error- “Insert Disk”	There is an old speednet CAB file present in OS installation folder. Please search for sp*.cab file in C:\Windows or C:\Winnt folder. If found delete them. Then install the package afresh
While installing system is asked to be restarted every time.	Check whether Service Pack SP 4 for Windows 2000 or SP3 for XP systems are installed.
While installing – error MSDART.dll file	If the following error occurs during the Client installation – “The Procedure entry point couldn’t be located in the dynamic link library MSDART.DLL.” When the error occurs – Click on OK. Then next it will show a file registration error – Click on Ignore. Then again the MSDART.DLL error occurs . Click on OK Then next it will show another file registration error – Click on Ignore Now it will install. Now package gets installed. This error will not cause any problem in the package. Note: If any Version Conflict messages appears, then keep the existing files in the system and continue the installation.
At the end of the installation error – “Path not Found”	Click on Retry button to continue. If this doesn’t solve the problem, reinstall the client component.
Active X Component Error – Found at any stage during installation.	Check whether Service Pack SP 4 for Windows 2000 or SP3 for XP systems are installed. Also install MDAC 2.7 If using Speednet 3.1 then download the 3.1.1 version from site.
Installation problem in Vista System for the first time	Right click on the setup.exe file and select option. This will install the package without any problem. Also register all the dll files which are in the SpeedNet Client Installation folder. To register the dll: · Right click on Dll file and select Open with · Select Browse option and go to Windows\System 32 folder. Select Regsvr32 file · Select open and ok button in the subsequent forms. · This will show the successful registration message. · If this process is not registering the Dll then :- please uninstall the SpeedNet client and ensure that old installation files doesn’t exist in the system. Then go to start->Run and type msconfig. A System Tools window opens. Click on Tools option. Search for option from the list. Select it and click on Launch. Restart the system then install the SpeedNet client and then register the Dlls. At the end don’t forget to go to msconfig ->Tools and select and launch and restart system. Note: Enable User Account Control is a must as it is a new security component in Windows Vista.
Configuration – Database Creation
While creating the database, message appears as – “Unable to load the configuration file”	Uninstall the SpeedNet Client component from Control Panel –Add Remove Programs and reinstall it.
While creating the database, “Speed Net found an illegal tampering of information... Quitting”	Uninstall the SpeedNet Client component from Control Panel –Add Remove Programs and reinstall it.
While creating database error – “SQL Server error. Please close all applications”	This is the error related to Hard disk. Check the following. · Drive letter provided is wrong · POSPCC and POSPCCBackup files exist in hard disk · No space in the hard disk.
While creating the database error – “Specified SQL Server not found”	The Server name provided is wrong. Please also check whether you have installed SQL as Instance. If so, edit the SQL Server name with SQL Instance name.
While creating the database error “Login failed for user SA”	The SQL Password typed is wrong.
In vista – shared file is not being accessed at the end of client installation.	In cases where new systems are supplied to project arrow offices, some problems in accessing server component folder even after sharing this folder may occur due to architecture of new OS installed in these systems. IN such case system administrator should overwrite defaults permissions given to SpeedNet server folder : To do this they can follow the procedure below: If it is vista operating system do the following steps before configuring the permissions: 1. Go to Start->Run and type msconfig 2. Under Tools, select Disable UAC and click on Launch button given below. 3. Restart the system. 4. Applying the permission changes to SpeedNet server folder as given below. Permissions: 7) Right click SpeedNet Server folder, select Properties ->Security tab and click on button therein. 2) Select the user if already present in the list there or Click on Edit and then button. Type everyone and click on OK. 3) In the next screen, check on permission for Allow. 4) Click on advanced 5) Uncheck the check box . A new option screen appears wherein click on remove button 6) Now click on OK button and Ok button in the previous screen. 7) Share the SpeedNet server folder and assign full permission to user on shared folder. Give similar permissions to user as above.
Configuration – Other Issues
While configuring, the required SPC name is not found for selection. Then how to install?	The procedure is explained in the SpeedNet Hand Book supplied along with 3.1 version release and the copy of the same is available in Speednet 3.1 CD. (Refer 2.8)
Error Inserting Offices to OfficeMaster –Could not bulk insert. File ‘SPCMaster.txt’ does not exist	This problem is solved in Speednet 3.1.1. You are using older version. Please download the 3.1.1 version and upgrade.
While configuring at linked office, Linked office name not found for selection. How to install?	The procedure is explained in the SpeedNet Hand Book supplied along with 3.1 version release and the copy of the same is available in Speednet 3.1 CD. (Refer 2.9)
“Automation Error” at the time of configuration	Solution 1: Dll Registry problem. Please open the Speednet client folder path (C:\Program Files\Speednet default folder) . Register all the dll files using the regsvr32 file. Procedure to register: 1. Right click on The dll file 2. Click on – Open with option 3. Browse – C:\Windows\System32 4. Select the file regsvr32.dll 5. Click on Ok to register. If it is Vista System and there is problem in registration of Dll files, please see the solution given at the heading – as to how to register the dll files in vista.
While configuring Error - "Text property read only"	This is the problem with old cab file remaining in the system during fresh installation of SpeedNet 3.1.1 Uninstall Speednet client from Add Remove programs Search for C:\Program Files\Speednet folder ( Its default path of client folder) . If exists delete it. Now go to search option ( or Find) of windows and search for spcl*.cab file in C:\Windows folder. If any such file exists delete it. Then install the Speednet Client 3.1.1 afresh.
Login
While starting the package itself, there is error “Error in Opening the Connection 70. Permission denied”	This problem would have occurred in Vista systems. As a solution, right click on the SpeedNet exe and click on Run As Administrator option and click on Allow to run the package.
While logging in it says the user is already logged in other system.	This problem is solved in Speednet 3.1.1. You are using older version. Please download the 3.1.1 version and upgrade.
Error while logging in – “Not a valid Password”	This is mdb file access error through the client system. Check the sharing permissions of the SpednetServer folder at server system. Whether the XP client user has been given full permission to access the folder. If by giving permission if the problem is not solved, then reinstall the SpeedNet Server component and share it afresh with full permission to (BNPL Module – old bill data will be lost with the re installation of SpeedNet Server)
Error while login – “BNPL Database is not found in the specified path”	This problem is solved in Speednet 3.1.1. You are using older version. Please download the 3.1.1 version and upgrade.
Login is very slow and takes too much time.	Login as Supervisor – Use Tools->Delete Old data option. Use Truncate option to truncate the log files of POSPCC and POSPCCBackup. (Please ensure that no one uses SpeedNet at that time, else DB will be corrupt)
While Logging in Vista Systems, when selected user, given password and click on OK, package simply exists without any message or error	Right Click on the Speednet.exe which is in the SpeedNet client path (default client path is C:\Program Files\SpeedNet) and click on. If this is not working then please share the SpeedNet Server folder in the Server System with Special Permission as given in the instruction at the heading
Shift Begin /Shift End
While making Shift End error – it gives BNPL Error / Pending Message error	This problem is solved in Speednet 3.1.1. You are using older version. Please download the 3.1.1 version and upgrade.
While making the Shift Begin – it shows the error that system date and time is incorrect.	Please check whether the System date is Current Date. From SpeedNet 3.1 onwards , package will not allow to make the Shift Begin for a date for which already Shift Begin and Shift End are done.
While making shift End – it shows a big list of non dispatched bags.	This is not an error. Please read the SpeedNet User Manual or for details on Non Dispatched Bag List.
While making the Shift End – Package exists automatically	Please read the SpeedNet User Manual for details on Shift End for Non Dispatched Bag List. If the list contains huge number of pending bags due to incomplete work in the package, then this happens. Reinstallation is the solution.

Courtesy : http://satish24k.blogspot.in

---------------------

Related Post:

• Release of Revised MNOP Script ( dtd 24/01/2012)

• Workflow of Despatch and Speednet

• Release of Revised MNOP Script (dtd 10/1/2012)

• Relesed of Revised MNOP Script ( dtd 28/12/2011)

• Speednet3.1.2 15/12/2011 DBPacth 1

• Release of Revised MNOP Script (dtd 19/12/2011)

• Annual Speed post Awards Scheme

• SpeedNet 3.1.2 - Revision Update - 15/12/2011