SQL30080N error points to two documents SC31-6160 and (SC31-6156

If I face this problem: SQL1476N with sqlerror "-30080", then I check this other error:

db2 ? sql30080   SQL30080N  A communication error "<reason-code>" occurred sending or       receiving data from the remote database. ... Refer to the document IBM Communications Manager 1.0 APPC Programming Guide and Reference (SC31-6160) for explanation of the APPC primary and secondary return codes. For details of APPC sense data, refer to the IBM Communications Manager 1.0 Problem Determination Guide (SC31-6156). 

When can I get information about these documents?

  • IBM Communications Manager 1.0 APPC Programming Guide and Reference (SC31-6160).
  • IBM Communications Manager 1.0 Problem Determination Guide (SC31-6156)

Reference:

https://www.ibm.com/docs/en/db2/11.5?topic=SSEPGG_11.5.0/com.ibm.db2.luw.messages.sql.doc/sql28000-sql33999.html#sql30080n

SEREMails error

Getting this error on catchall emails on seremails :-1:
POP3 Login failed – -ERR [IN-USE] You already have a POP session for this account running on another server. Try again later.
Anyone had this error before ?

Error while Running query in postgreSQL from sql server 2016

The below query runs well in sql server 2016:

 select ResellerId, vCompanyName ,x.*  from wlt_tblReseller AS main  outer apply ( select (count (ipkReportTypeId)) AS "count", vReportTypeName                 from wlt_tblReseller _all                inner join wlt_tblClient clients  on clients.ifkParentResellerId = _all.ResellerId               inner join wlt_tblReport_CompanyMaster reporslogs on reporslogs.ifkCompanyId = clients.ClientId               inner join wlt_tblReports_TypeMaster rpt_types on rpt_types.ipkReportTypeId = reporslogs.ifkReportTypeId                where RootResellerId = main.ResellerId                  and rpt_types.bStatus =1                  and bIsStatic =1                  and vReportTypeName  is not null               group by ipkReportTypeId,vReportTypeName             ) AS x  WHERE IsMiniReseller = 0    and ResellerId <> 1     and vReportTypeName is not null  order by  vCompanyName desc  

But when I take it to postgreSQL and change outer apply to LEFT JOIN LATERAL,it does not run and produces the following error:

ERROR: syntax error at or near "WHERE" LINE 9: )AS x WHERE IsMiniReseller = 0 and ResellerId <> 1 and v… SQL state: 42601 Character: 649

What could I be missing?Any help will be much appreciated.

Regards Chris.

Unity2D – Rotation of gun following mouse error when parent ‘player’ object rotates

I have a bug I’ve been trying to fix with the rotation of a gun object that follows the mouse position but has issues when the parent object player rotates. Example:

Example of rotation error

The player has a gravity script to keep them aligned with the ‘planet’ as you walk around it. The gun as a child of the player, is supposed to always rotate to point at where the mouse is (sorry you can’t see it in the gif). The gun normally flips itself at 90 and -90 (top and bottom), and flips the player to face the same side the mouse is on.

The problem is that the player rotates to stay aligned with the planet, but the 90 and -90 angles that the gun bases flipping itself and the player off of course don’t rotate.

Here’s my code for the gun:

         Vector3 difference = Camera.main.ScreenToWorldPoint(Input.mousePosition) - transform.position;           difference.Normalize();           float rotationZ = Mathf.Atan2(difference.y, difference.x) * Mathf.Rad2Deg;            float startRotation = rotationZ + offset;            float shotRotation = startRotation + Random.Range(-scatter, scatter);            transform.rotation = Quaternion.Euler(0f, 0f, startRotation);            //Flip the gun at top and bottom           if (rotationZ < -90 || rotationZ > 90)           {               if (player.transform.eulerAngles.y == 0)               {                   transform.localRotation = Quaternion.Euler(180, 0, -rotationZ + offset);               }               else if (player.transform.eulerAngles.y == 180)               {                   transform.localRotation = Quaternion.Euler(180, 180, -rotationZ + offset);               }           }            //Use gun rotation to set player direction           //left           if (rotationZ >= -90f || rotationZ <= 90f)           {               animator.SetFloat("Vertical", 0);               animator.SetFloat("Horizontal", -1);           }           //right           if (rotationZ <= -90f || rotationZ >= 90f)           {               animator.SetFloat("Vertical", 0);               animator.SetFloat("Horizontal", 1);           }

Making plots with data and error bars (non linear fit)

I have some data from let’s say x,y which I would like to plot with error bars. I have the error from y only, it is 5% of each value of y. I have already made the plot, but I need to do a non linear regression so I need the error bars too. Can someone tell me how they would solve this? This is my data: \left( \begin{array}{cccccccccccccccccccccccccccccccccccccccccccccccccccccc} \text{w} & 9.43396\times 10^{11} & 1.11524\times 10^{12} & 1.27119\times 10^{12} & 1.5\times 10^{12} & 1.81818\times 10^{12} & 2.0979\times 10^{12} & 2.4\times 10^{12} & 2.7027\times 10^{12} & 3.\times 10^{12} & 3.30033\times 10^{12} & 3.60144\times 10^{12} & 3.90117\times 10^{12} & 4.20168\times 10^{12} & 4.49775\times 10^{12} & 9.375\times 10^{12} & 1.\times 10^{13} & 1.07143\times 10^{13} & 1.15385\times 10^{13} & 1.25\times 10^{13} & 1.36364\times 10^{13} & 1.5\times 10^{13} & 1.66667\times 10^{13} & 1.875\times 10^{13} & 2.14286\times 10^{13} & 2.5\times 10^{13} & 3.\times 10^{13} & 3.75\times 10^{13} & 4.28571\times 10^{13} & 5.\times 10^{13} & 6.\times 10^{13} & 7.5\times 10^{13} & 1.\times 10^{14} & 2.41935\times 10^{13} & 3.62757\times 10^{13} & 4.83871\times 10^{13} & 6.04839\times 10^{13} & 7.26392\times 10^{13} & 8.47458\times 10^{13} & 9.67742\times 10^{13} & 1.08696\times 10^{14} & 1.20968\times 10^{14} & 1.33333\times 10^{14} & 1.44928\times 10^{14} & 1.57068\times 10^{14} & 1.69492\times 10^{14} & 1.81818\times 10^{14} & 1.93548\times 10^{14} & 2.05479\times 10^{14} & 2.17391\times 10^{14} & 2.29008\times 10^{14} & 2.41935\times 10^{14} & 3.61446\times 10^{14} & 4.83871\times 10^{14} \ \text{$ \_$ e1} & 86163. & 87360. & 94656. & 91800. & 98651. & 96012. & 99663. & 100277. & 106095. & 103455. & 104075. & 97200. & 96632. & 93841. & 36860.2 & 33660.4 & 30573.8 & 27251.8 & 24086.8 & 20788.4 & 17700.8 & 14833.1 & 12194.3 & 9511.71 & 7142.4 & 5054.19 & 3293.46 & 2535.89 & 1875.78 & 1306.64 & 839.438 & 474.75 & 6789.09 & 3077.6 & 1734.35 & 1113.63 & 771.86 & 565.878 & 432.292 & 342.029 & 275.408 & 227.901 & 190.362 & 161.232 & 139.192 & 118.774 & 104.008 & 91.5593 & 81.1576 & 72.0605 & 64.464 & 24.794 & 9.9687 \ \text{e2} & 623116. & 537272. & 481490. & 399798. & 336540. & 282384. & 247384. & 215364. & 193112. & 168392. & 148932. & 129600. & 114426. & 78960. & 25371.2 & 21734.4 & 18382. & 15253.2 & 12448. & 9886.4 & 7670.4 & 5778.4 & 4188.8 & 2859.4 & 1840.32 & 1089.66 & 567.936 & 382.79 & 242.172 & 141.18 & 72.5 & 30.52 & 1352.95 & 412.552 & 177.642 & 92.852 & 55.044 & 35.7 & 24.544 & 17.39 & 12.948 & 9.966 & 7.728 & 6.096 & 5.192 & 4.142 & 3.672 & 3.0624 & 2.703 & 2.3772 & 2.0878 & 0.7968 & 0.8216 \ \text{erroe1} & 4308.15 & 4368. & 4732.8 & 4590. & 4932.55 & 4800.6 & 4983.15 & 5013.85 & 5304.75 & 5172.75 & 5203.75 & 4860. & 4831.6 & 4692.05 & 1843.01 & 1683.02 & 1528.69 & 1362.59 & 1204.34 & 1039.42 & 885.038 & 741.656 & 609.716 & 475.586 & 357.12 & 252.709 & 164.673 & 126.794 & 93.7888 & 65.3319 & 41.9719 & 23.7375 & 339.455 & 153.88 & 86.7177 & 55.6814 & 38.593 & 28.2939 & 21.6146 & 17.1015 & 13.7704 & 11.3951 & 9.51808 & 8.06162 & 6.95958 & 5.9387 & 5.20038 & 4.57797 & 4.05788 & 3.60303 & 3.2232 & 1.2397 & 0.498435 \ \text{erroe2} & 31155.8 & 26863.6 & 24074.5 & 19989.9 & 16827. & 14119.2 & 12369.2 & 10768.2 & 9655.6 & 8419.6 & 7446.6 & 6480. & 5721.3 & 3948. & 1268.56 & 1086.72 & 919.1 & 762.66 & 622.4 & 494.32 & 383.52 & 288.92 & 209.44 & 142.97 & 92.016 & 54.483 & 28.3968 & 19.1395 & 12.1086 & 7.059 & 3.625 & 1.526 & 67.6476 & 20.6276 & 8.8821 & 4.6426 & 2.7522 & 1.785 & 1.2272 & 0.8695 & 0.6474 & 0.4983 & 0.3864 & 0.3048 & 0.2596 & 0.2071 & 0.1836 & 0.15312 & 0.13515 & 0.11886 & 0.10439 & 0.03984 & 0.04108 \ \end{array} \right) And this is the plot I made and where I want the error bars enter image description here

THANK YOU!

ColorFunction in ListContourPlot3D raising error when using more than one argument

The documentation of ColorFunction states that in ListContourPlot3D your chosen function gets the arguments x, y, z and f. However, if you actually use any argument other than the first an error is raised in Mathematica 12.2, yet strangely enough the plot is (most of the times) shown as expected.

Consider for example

list1 = Table[{x, y, z, x^2 + y^2 - z^2}, {x, -1, 1, .05}, {y, -1, 1, .05}, {z, -1, 1, .05}]~Flatten~2;  ListContourPlot3D[list1, Contours -> {0.3}, PlotRange -> {{-1, 1}, {-1, 1}, {-1, 1}}, ColorFunction -> Function[{x, y, z, f}, Hue[z]], ColorFunctionScaling -> False] 

This produces the error

Function::fpct: Too many parameters in {x,y,z,f} to be filled from Function[{x,y,z,f},Hue[z]][0.3]. 

But the generated graphics seem OK: ColorFunction in ListContourPlot3D

Is this a bug, or am I doing something wrong here?