SoftPro Developer Forum

Hi Bob, Yes, those are our custom lookup tables. Problem is that this error happens from time to time. From what we've gathered we were getting it when our staging servers were low on resources. Once we increased the RAM memory and the CPU, they stopped happening. Now, we are receiving them in our p...

We are receiving the following error in our custom code: There is already an object named 'lkuptgr_F3BD9356_CBB5_45E2_AAAA_C253CEB5C66F' in the database. SoftPro.ClientModel.Proxies.ClientProxy`1.OnHandleFaultException(FaultException exception) at SoftPro.ClientModel.Proxies.ClientProxy`1.HandleFaul...

Since this is staging server and we need to get it up and running ASAP, using identical ports resolved our issue.
Next step will be to use VPN instead.
Thank you!

We have SoftPro Select server installed on virtual machine in our local network. Now we need to access the SoftPro server from our staging server (over the internet), but due to security concerns we can't use 8080 port. Locally we use http://softpro:8080 to access it. Access from the internet is set...

Thank you Bob, that was helpful!

Thanks for your input Bob. I did try that, but it looks like intermediate materialization happens right after calling lookups.QueryTable(spec) - whole collection will be fetched and stored in memory before Skip() and Take() do any effect. Skip() and Take() will basically only slice number of rows fr...

Is there a way to get paged results from lookup tables? Some lookup tables contain thousands of records and we're concerned we may run into timeout issues when fetching large amount of data in one call. I couldn't find anything regarding paging in SDK documentation and LookupQuerySpec doesn't seem t...