Search results

Problem: I am joining 5 tables together. Two of the joins are left joins. One of the left joined tables only has 2400 records and works fine. However the other left joined table contains 101,000 records and it is NOT joining. I am only able to get it to work by disabling the optimizer by...

Please Disregard this post! The problem is a data issue that stems from an apparent business process issue! I have a query here that is causing me a headache. I am using the timestampdiff function and passing it an interval of SQL constant type SQL_TSI_DAY. The function seems to work when...

Problem: I am on Progress 9.1D and I cannot build a query that gets me the information I need. Progress seems to only allow serial joins. Meaning, I must singly join each table one at a time; one before the other. I need the tables involved in Joins 2 and 3 to be cojoin before I join it to...

Hello, I have this query that is supposed to be a Left Outer Join, but it is producing a Cartesian product. Is anyone able to help? Perhaps you can execute this in your own test environment and see if you come up with the same result. Database: PROGRESS Version 9.1D0920 as of Tue Oct 19...

This one has me scratching my head. I'm not sure where to start. This happens whenever anyone logs into the application. "Service Transport TCP is busy" (5485) Any suggestions?

I am dealing with a problem and based on what I read online and on this forum, I may need to create a secondary broker. I tried this a number of times, a number of different ways and it failed. I am new to Progress so I really don't know what I am doing :awink::lol:. According to the...

I feel like I'm stuck on an island. Epicor does not appear to have the expertise to help and I cannot find an answer on the web, after scouring it for days. I started a thread on this forum in hopes of getting support, but it has 40 views and no responses - even after personally reaching out...

Hello all, I have been trying to solve this problem for over the last 4 days and I need help. The error message indicates that there is a security restriction, but I cannot confirm this. Please have a look below. Database Version : PROGRESS Version 9.1D0920 as of Tue Oct 19 20:04:28 EDT...